Re: long raw datatype

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 26 Jan 1999 02:29:50 GMT
Message-ID: <36ad286d.262176@192.86.155.100>

A copy of this was sent to Zhong Chen <zchen_at_hal.com> (if that email address didn't require changing) On Mon, 25 Jan 1999 13:12:42 -0800, you wrote:

>We installed the "utlraw" package. We run this sql command (BlobSeg field is long
>raw type)
> select sys.utl_raw.cast_to_varchar2(db.BlobSeg)
> from db
> where (db.id=101)
>And I got following error: ORA997 illegal use of Long "datatype".
>Seems this "utl_raw.cast_to_varchar2" function only works for "raw", not for "long
>raw". Is there any other functions available for "long raw"?
>Thanks.

do this instead:

   for x in ( select blobseg from db where id = 101 ) loop

      some_other_variable := utl_raw.cast_to_varchar2(x.blobseg);
      ....

   end loop;

you cannot apply functions to LONG RAWs in sql..

>
>Zhong Chen
>Hal computer systems
>
>Thomas Kyte wrote:
>
>> 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
>>
>> ----------------------------------------------------------------------------
>> Opinions are mine and do not necessarily reflect those of Oracle Corporation
>>
>> 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.
>
>
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

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 Mon Jan 25 1999 - 20:29:50 CST