Danny Tramnitzke wrote: > > Hi all > > I have a problem with insert the current user into a table. > > The Table : > > Create Table test (id smallint not null, name varchar2(20) not null) > > created with ORACLE mode, doesn't want to take the user, so that > > insert into test (id, name) values (5, user) > > causes an Error : > > Auto Commit: On, SQL Mode: Oracle, Isolation Level: Committed > Error in assignment;-8004 POS(41) Constant must be compatible > with column > type and length. > insert into test(id, name) values (1, user) > > > But the user, I'm logged in is just "test01" , so it has not > more than 20 > chars. > > The strange thing with that is, that I can insert the user into a > varchar(255) field. > So, where lies the Error (bug?)
Every (var)CHAR(2) (n) with n >= 32 will do; the check for minimal character-column-length is done before checking the current name. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
