Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Using SQL*Plus for loading file containg CR/LF as value of colum
Hello,
I have a data transfer from an application, where this other application
creates a file containing SQL's. Some times it happens that the user write
some blank lines in this "other application", which make the VALUES-part of
the INSERT contain CR/LF's. A little simplified the INSERT in the text-file
to be spooled into SQL*Plus looks like this:
INSERT INTO HTable (UId, descr, numb) VALUES (63184283, 'THIS IS THE FIRST LINE THIS IS THE THIRD LINE ', 123);
SQL*Plus gives an error message of this type:
SP2-0734: unknown command beginning "', 123.." - rest of line ignored.
Is there any way to make SQL*Plus understand that the CR/LF's are part of the data to be inserted into the table?
Thanks for any help!!
Regards,
Randi Wølner
Received on Tue Jan 28 2003 - 07:54:20 CST