Re: search a string in a blob

From: Keith Jamieson <Keith.Jamieson_at_phoenix.ie>
Date: Thu, 2 Nov 2000 18:04:33 -0000
Message-ID: <8tsafk$t5b$1@kermit.esat.net>

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.
Received on Thu Nov 02 2000 - 12:04:33 CST