Re: Problem with a long column in Oracle 8.1.X

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 27 Nov 2001 10:48:00 -0800
Message-ID: <9u0n500as7@drn.newsguy.com>

In article <30c35a4a.0111270828.9259ae8_at_posting.google.com>, amir_at_have-it.de says...
>
>I try to write in a column (long) and it fails with an error of
>ORA-01704: string literal too long.
>My string is over 10000000 character.
>
>How can i do it?

you need to use a bind variable. How you do that varies by programming language of course.

You will not be doing this with sqlplus.

In 8i, you should not be using a LONG, you should use a clob (in which case you could use sqlplus since its probably a file you want to load and a simple dbms_lob.loadfromfile would do it for you)

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Tue Nov 27 2001 - 12:48:00 CST