Re: Problem with Long

From: <steveorr_at_my-deja.com>
Date: Thu, 17 Aug 2000 16:24:28 GMT
Message-ID: <8nh3j4$4si$1@nnrp1.deja.com>

Try Using PL/SQL and CLOB datatypes.

In article <8ngvov$9sa$1_at_reader1.fr.uu.net>, "Jérôme Texier" <jt_at_ystel.fr> wrote:
> Hello,
>
> we have a small concern on one of our

applications functioning under Oracle
> 8i and developed in Php.
> The error is met:
> "ORA-01704 string literal too long
> Cause: A quoted string specified as a constant
was too long.
> Action: Quoted strings may not contain more
than 2000 characters"
> when one wants to insert character strings
higher than 2000 characters in
> fields of the long type.
> The Insert command goes (neither in Php, nor
under SqlPlus).
> How can one solve the problem?
>
> Thanks for your answer.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 17 2000 - 11:24:28 CDT