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

From: Richard Sutherland <rvsutherland_at_yahoo.com>
Date: Sun, 25 Feb 2001 07:07:37 -0500
Message-ID: <t9hsreg4h8i2d6@corp.supernews.com>

Within SQL*Plus and before starting your script, enter

set define off

This will prevent SQL*Plus from searching for substitution characters.

HTH Richard Sutherland

Ronggolawe <radenjava_at_theglobe.com> wrote in message news:20010225.035116.1171.458_at_theglobe.com...
> 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 - 06:07:37 CST