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?)
Best regards, Danny
-- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
