Re: instr on LONG?

From: Mark D Powell <mark.powellNOmaSPAM_at_eds.com.invalid>
Date: 2000/07/19
Message-ID: <00d08fea.d405796c@usw-ex0102-015.remarq.com>#1/1

honza_v_at_my-deja.com wrote:
>Is there any (preferably easy:) way to use function instr on
LONG column
>in the query? I tried to convert it with TO_LOB and to use
>dbms_lob.instr on it, but with no succes. Any suggestions?
>
>Jan
>

If the contents of the long are <= 32K you can read it into a pl/sql varchar2(32767) variable and use the pl/sql instr function on it. Otherwise you are into piece-wise fetching.

The conversion to a lob and use of the dbms_lob package should be the way to go. Are you sure something like case or spelling isn' the cause of your problem?

There are numerous posts by Thomas Kyte on longs and piece-wise fetching. You may want to hunt through the archives.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 19 2000 - 00:00:00 CDT