Re: Need substring of a long field - help please

In general, the error is because LONG data type is not allowed in SUBSTR

Suggested PL/SQL solution would work only in cases when actual length of LONG data is less than the declared length of PL/SQL variable. Perhaps this enough, if actual data length does not exceed 32000...

SY
Anton

ALEX J JENTILUCCI wrote in message
<6itl3g$4qfs$1_at_newssvr04-int.news.prodigy.com>...
>Hi Amy,
>
> Though you didn't specify what you're doing, I assume (reluctantly)
that
>you are using SQL*PLUS.
>If so, I don't have any ideas, but I do know what you are doing with SUBSTR
>is not allowed.
>
>On the other hand if you can use PL/SQL you could declare a variable of 255
>characters (Could be up to 32000) then select your LONG into it and you're
>done. Or you could do any other string function on the PL/SQL
>variable.
Received on Fri May 08 1998 - 02:17:09 CDT