Re: read longRaw

From: Adam Spindler <adams_at_est.co.uk>
Date: Tue, 12 Mar 2002 12:36:52 +0000
Message-ID: <3C8DF664.5070906@est.co.uk>

Lars Windels wrote:
> Hello.
>
> Is there a way to read data from a longraw column in plsql?
> I want to compare the column-entry (a textfile) with a specified string.
>
> can anybody help me.
>
> Best regards Lars Windels.
>
>

If you use :

L_str := UTL_RAW.CAST_TO_VARCHAR2(L_raw); -- convert raw chunk to varchar

You can then use an INSTR(L_str, <string to find>, 1,1)

to match the string Received on Tue Mar 12 2002 - 06:36:52 CST