Guido...
change the datatype! :-)
Of course, you can't.
Well, have you tried with a Pl-Sql anonymous block?
or...
Oracle says that using BIND variables you can get more
than 4000 chars...
have you tried with bind vars?
HTH
JL
- Guido Konsolke >
>
> > Hi dear list members,
> >
> > we run a database 8.1.6.2
> > I've run into a problem. I've got a table that
> > contains a LONG column (I know, I know).
> > I have to insert a string into it that has a
> length > 8500 Byte.
> > Whenever I issue the insert statement SQL/PLUS
> throws
> > the error 'ORA-01704: string literal too long'.
> >
> > Does anyone have an idea how I can get the data
> > into the table?
> >
> > Any help (except: change the datatype ;-)) is
> appreciated.
> >
> > Greetings,
> > Guido
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > --
> > Author: Guido Konsolke
> > INET:
> Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com
> >
> > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > San Diego, California -- Mailing list and
> web hosting services
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Arup Nanda
> INET: orarup_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Guido Konsolke
> INET:
> Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Received on Wed Jul 16 2003 - 09:46:50 CDT