Inserted value too big

From: Robert Wehofer <thalion77_at_graffiti.net>
Date: Wed, 14 Dec 2005 15:08:25 +0100
Message-ID: <d5838$43a02706$d4badae4$25967@news.chello.at>

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 Received on Wed Dec 14 2005 - 08:08:25 CST