Re: converting LONG RAW to BLOB

From: Raja <rajasekharv_at_hotmail.com>
Date: Thu, 28 Dec 2000 15:20:06 -0800
Message-ID: <92ghr7$45i@news.or.intel.com>

If it is Oracle 8.1, try using the new SQL operator, TO_LOB. TO_LOB copies data from a LONG column in a table to a LOB column. The datatype of the LONG and LOB must be the same for a successful copy. For example, LONG RAW data must be copied to BLOB data, and LONG data must be copied to CLOB data.

Thanks
-Raja

Vanessa wrote in message <92g25r$nrq$1_at_nnrp1.deja.com>...
>Help - we want to migrate our data from tables with columns defined as
>LONG RAW to tables with columns defined as BLOB. I have tried the
>dbms_sql utility and export/import utility and while functionally these
>scripts work fine - I always run into some sort of error about improper
>use of LONG, or cannot bind LONG data to a column that is not. I have
>also tried to use the RAWTOHEX function but it is as though that
>function is not at all recognized!
>
>I am using Oracle 8. Any suggestions are welcome. TIA
>
>-Vanessa
>
>
>Sent via Deja.com
>http://www.deja.com/
Received on Thu Dec 28 2000 - 17:20:06 CST