Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with Long

Re: Problem with Long

From: Jérôme Texier <jt_at_ystel.fr>
Date: Fri, 18 Aug 2000 08:50:07 +0200
Message-ID: <8nin2c$1g$1@reader1.fr.uu.net>

So I must cut out my fields in several other fields?

For what is used the Long type in it case ?

<steveorr_at_my-deja.com> wrote in message news:8nh3j4$4si$1_at_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 Fri Aug 18 2000 - 01:50:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US