Re: 'substring' a LONG column

From: Martin <mjones.satisdata_at_btinternet.com>
Date: Thu, 20 Sep 2001 19:13:32 +0100
Message-ID: <9odbjk$pmq$1@uranium.btinternet.com>

Hi, investigate the dynamic sql package DBMS_SQL - I believe in v8 and above you can piece-wise traverse a LONG.

Good luck.

"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 Thu Sep 20 2001 - 13:13:32 CDT