Re: Oracle RAW data type -- What's it all about?

From: flitelog <flitelog_at_yahoo.com>
Date: 7 Feb 2002 12:02:10 -0800
Message-ID: <54072b43.0202071202.7ff5508d@posting.google.com>

>
> Normally data stored in a RAW is binary data. I believe that SQLPLUS
> automatically performs a RAWTOHEX function on it. Try coding the
> funtion into your application call: select rawtohex(column_name) from
> .... There is also a rawtohex function.
>
> -- Mark D Powell --

Mark,

Thanks for the answer. But it only solves part of my problem.

My ASP code is generic enough that I don't know the type of the data field before I issue the sql, so doing a RAWTOHEX is not possible at that point.

What I really need to know is how to identify the binary data (RAW) in an ASP record set returned from Oracle, so I can convert it to Hex on the ASP side.

Any ideas?

Mike Received on Thu Feb 07 2002 - 14:02:10 CST