Re: Help me on CLOB, XML and "&" character

Thanks for everyone help.

In article <20010225.035116.1171.458_at_theglobe.com>, "Ronggolawe" <radenjava_at_theglobe.com> wrote:

> 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
> &amp; 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 Mon Feb 26 2001 - 15:53:11 CST