Re: converting LONG RAW to BLOB

From: Vanessa <vanessa_ide_at_my-deja.com>
Date: Tue, 02 Jan 2001 13:53:55 GMT
Message-ID: <92smhh$rms$1@nnrp1.deja.com>

I am NOT on 8.1. I am on 8.0 And yes, I am tryin gto convert from LONG RAW to BLOB using the techniques I have listed with no success. Please help.
-Vanessa

In article <92ghr7$45i_at_news.or.intel.com>, "Raja" <rajasekharv_at_hotmail.com> wrote:
> 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/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 02 2001 - 07:53:55 CST