Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: converting LONG RAW to BLOB
The best thing you can do is upgrade your database. 8.0 is going to drive you crazy.
If you cannot upgrade, it much easier to do this in C using the OCI interface. You will have to read your LONG RAWs in buffers and write it to BLOBs in buffers. Simple to program but tedious to write.
"Vanessa" <vanessa_ide_at_my-deja.com> wrote in message
news:92smhh$rms$1_at_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 Thu Jan 04 2001 - 10:06:34 CST