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

That application should generate:

    insert into ..... values (..., 'this is the first line'||chr(13)||'second line' ,...)
Character 13 is the decimal value of the CR character. Character 15 is the decimal value of the LF character, mayby you need to concatenate it too.

Randi Wølner <randiwolner_at_hotmail.com> schreef in berichtnieuws b161v8$m77$1_at_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 Wed Jan 29 2003 - 02:21:14 CST