Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: search a string in a blob
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
![]() |
![]() |