Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Using SQL*Plus for loading file containg CR/LF as value of colum

Using SQL*Plus for loading file containg CR/LF as value of colum

From: Randi Wølner <randiwolner_at_hotmail.com>
Date: Tue, 28 Jan 2003 14:54:20 +0100
Message-ID: <b161v8$m77$1@oslo-nntp.eunet.no>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US