Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: long raw datatype
A copy of this was sent to Zhong Chen <zchen_at_hal.com>
(if that email address didn't require changing)
On Fri, 22 Jan 1999 12:08:46 -0800, you wrote:
>experts,
>
>I have a oracle database, one field in a table is defined as long raw. I
>know this field contains a long string. Is there any function I convert
>them to variant type. I checked the ref. book, only find this functin
>"rawtohex", but it won't work on the "long raw" type.
>Thanks for your help.
>
>Zhong Chen
>Hal computer systems
try
utl_raw.cast_to_varchar2()
that will convert a RAW type into a string with no conversions (just changes the datatype of the variable).
utl_raw may not be installed in your instance (if you don't have replication or procedural gateways, its probably not). to install, look in $ORACLE_HOME/rdbms/admin for *raw* and install the spec and body using SVRMGRL when connected as INTERNAL or SYS (not as system, not as anyone else, only as INTERNAL or SYS)
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Jan 22 1999 - 15:21:39 CST