Re: Problem with Long

Try using PL/SQL VARCHAR2(4000) or you can used two columns column1 varchar2(4000)+column2 varchar2(4000)

steveorr_at_my-deja.com schrieb:

> 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 - 13:40:54 CDT