Re: Inserted value too big

Robert Wehofer schrieb:
> Hello!
>
> I would like to execute following statement in Oracle 9i SQL Worksheet:
>
> insert into rp_themeright_definition values (42, 'Sachdaten erstellen &
> löschen', 3);
>
> I get the following error message:
>
> Enter a value for deleting: old 1: insert into rp_themeright_definition
> values (42, 'Sachdaten erstellen & löschen', 3)
> new 1: insert into rp_themeright_definition values (42, 'Sachdaten erstellen
> OEM_sqlplus_input_finished', 3)
> insert into rp_themeright_definition values (42, 'Sachdaten erstellen
> OEM_sqlplus_input_finished', 3)
> *
> ERROR in line 1:
> ORA-01401: Inserted value to big for column
>
> What can I do to insert a string value containing the & character?
>
> Regards,
> Robert
>
>

One of possibilities would be to "set define off". http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14357/ch8.htm#sthref1566

Best regards

Maxim Received on Wed Dec 14 2005 - 08:27:03 CST