you probably have some &... aliases in your HTML text - sqlplus tries
to replace them with variables. SET SCAN OFF will prevent this.
SET DEFINE OFF is preferred though as SET SCAN is obsolete in 9i and
SET DEFINE overrides any SET SCAN settings.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3cbafb05$0$8514$ed9e5944_at_reading.news.pipex.net...
> if you are using sqlplus try issuing the command set scan off.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "RonB" <r.borkent_at_chello123.nl> wrote in message
> news:V2Bu8.1269352$hy4.46921841_at_Flipper...
> >
> > Hi,
> >
> > I'm trying to insert some html code in a clob column but keep getting
> > errors. I suspect is has something to do with characters since sql plus
> > keeps asking me to input values for variables :-) some help would be most
> > welcome
> >
> > RonB
> >
> >
>
>
Received on Mon Apr 15 2002 - 13:39:53 CDT
