I have a small problem. I have developed a SQL script that will insert a long string into a table. I have to mention that the string is about 1300 characters, and that it contains the & character. What I have did is something like what you have shown in the code snippet.
My problem is that when running this script in a development enviroment, using Toad 7.3 to run the script, all goes well.
When this script is executed in production enviroment with SQLPLus , well in the table, my string is getting broken by a space wich somehow is beeing insert in the string. It apears as if the statement modifies the string somehow:
insert into table(id, string) values (1, 'asasdasdsa&dsad asdsadsadsad&sad');
I really need your help, because I'm clueless.
set define off;
set linesize 2500;
insert into table(id, string) values (1, 'asasdasdsa&dsadasdsadsadsad&sad');