Re: How to do this

I tried using the UTL_Raw package as in:

Select UTL_Raw.cast_to_varchar2(S.ObjectMoniker) From CORESite S

It dumps out contents like this

p
E

for RAW values

700072006F006A00650063007400640062000000 4500230031003100340038003500350035003000380037000000

Any ideas what I might be doing wrong here ?

thanks
Sunit

sjoshi wrote:
> Hello All
>
> For SQLServer I could cast the ObjectMoniker coln which is of varbinary
> type to nvarchar to see if it's got the %OLE% string like in
>
> cast(S.ObjectMoniker as nvarchar(100)) like '%OLE%'
>
> How do I do this for Oracle ? In this case it is of type RAW(256). The
> doc.says that there is Implicit Conversion to char type but I'm getting
> only numbers when I try this :
>
> Select S.ObjectMoniker From CORESite S
>
> If I add the Where Clause, I get 0 rows
>
> Where S.ObjectMoniker Like '%OLE%'
>
> thanks
> Sunit
Received on Mon Oct 02 2006 - 08:50:52 CDT