Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Long strings....
It sounds like the tool you are using is truncating or not allowing the
strings. I have used strings much longer than 255 bytes in Oracle without a
problem. What happens in sqlplus?
Jim
"Andreas Koch" <akoch_at_rbg.informatik.tu-darmstadt.de> wrote in message
news:3A0D2BAC.E9738361_at_rbg.informatik.tu-darmstadt.de...
> Hi,
>
> i have an problem with long quoted strings.
>
> If i declare a column
> test : varchar2(250)
>
> everything works fine (with strings up to 250 chars).
>
> If i declare a column
> test : varchar2(1000)
>
> declaration works, but any SQL statement like
>
> update mytable set test='very long string with 400 chars ....';
> i get either "quoted string too long" (Sql Talk) error or the string
> is truncated to 254 chars (Toad).
>
> If i try to query such a column from my Centura app (select
> test from mytable into :sTest) , even if the stored string is
> shorter than 250 chars, i just get an empty result.
>
> So:
>
> How do i use strings longer than 254 chars?
>
>
>
> --
> Andreas
> Die letzten beissen die ersten.
>
Received on Sat Nov 11 2000 - 09:39:41 CST