Re: 'substring' a LONG column

From: Frank <franjoe_at_frisurf.no>
Date: Wed, 19 Sep 2001 22:44:07 +0200
Message-ID: <ju7q7.20805$1T5.248984@news1.oke.nextra.no>

Hi!

The LONG datatype has many constraints. Try to send the LONG column into a PLSQL function with a parameter
VARCHAR2(max 32000 characthers I think) and use substr inside the function, and return the 80 characthers from
the function. Such a function can be made possible to be callef from a SQL statement.

(not tested :-)
Frank

Richelle Hutchinson <rihutchin_at_columbus.rr.com> wrote in message news:u37q7.55438$Iq4.29737501_at_typhoon.columbus.rr.com...
> Does anyone know how to 'substring' a LONG field? We need to obtain the
> first 80 characters and the substring function won't work. Changing this
> column to a LOB datatype on the database is not an option at this time.
>
> Thanks in advance.
>
> -Richelle Hutchinson
>
>
Received on Wed Sep 19 2001 - 15:44:07 CDT