Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help me on CLOB, XML and "&" character
Hi, can anyone help me with this problem ?
I'm trying to insert a bunch of XML data to Oracle 8i, so I create table
docs with column (id number, xmldata CLOB).
However some of the XML data has some character such as & and USF&G,
thus when I execute sql script for inserting the data using sqlplus it
giving me some error such as:
Enter value for amp:
Enter value for g:
Can anyone tell me how can I excecute the script withoutsqlpus reading the
& character ?
Thank you very much for your help.
Received on Sun Feb 25 2001 - 05:51:22 CST