Re: search a string in a blob

Dear Keith,

thanks a lot for your advice. I had already given up any hope. I will try next Monday when our Oracle administrator will be back in the office and will have installed the utl_raw package.

Best regards
Violeta

In article <8tsafk$t5b$1_at_kermit.esat.net>,   "Keith Jamieson" <Keith.Jamieson_at_phoenix.ie> wrote:
> To convert strings from hex to raw and raw to hex you need to install
 the
> utl_raw package. This is not stored as default, but will do exactly
 what you
> want.
> It will be in the orcale admin directory
>
> ioleta1968_at_my-deja.com wrote in message <8teum7$rc6
 $1_at_nnrp1.deja.com>...
> >I need urgent help regarding blobs in Oracle8i databese on SuSe-
 Linux.
> >I'm trying to make a procedure searching for patterns in a blob The
> >procedure is allways invalid with errors regarding hextoraw or raw.
 I'm
> >making this procedure based on an example of technet.oracle.com
> >(EXAMPLE_13A).
> >Up to now I'm doing it by saving the blobs as clobs and searching in
> >the clobs.But this is no acceptable solution.
> >Can somebody give me an example or advice how to proceed?
> >Additionally I'd like to know how a string can be converted into raw-
> >or hextoraw format.
> >For your information: We have interMedia but we can not make it run
 on
> >Linux.
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 02 2000 - 14:28:35 CST