Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to copy LONG RAW data?

Re: How to copy LONG RAW data?

From: Chris <chris_at_foo.com>
Date: Thu, 23 Dec 1999 00:12:02 -0500
Message-ID: <3861AF22.5E127753@foo.com>


You can use ProC for this. I am not sure if the copy command in SQLPLUS can handle this, but it does offer enhanced copy capabilities, but I am not sure if that includes LONG RAW.

Tom Zamani wrote:
>
> Oracle Has provided us with long row and plsql, which are greate but PLSQL
> can not handel long rows very well at all!!.
>
> The only way that I can think of is using ProC, I have Used ProC for
> Archiving the Long Rows.
> BUT, You can not call it through PLSQL.
>
> If you want to use ProC, there are some very good example on metalink which
> goes through selecting and inserting longrows.
> Good luck
> Tom
>
> Anna Sotnichenko <annasony_at_home.com> wrote in message
> news:38616452.F96D2B98_at_home.com...
> > I use Oracle 7.3.4 under NT.
> > I need to copy a record containing a field of LONG RAW type
> > Statement
> >
> > insert into ....
> > select ... from ...
> >
> > does not work (which is an expected result since this is exactly what is
> > written in documentation).
> >
> > I read that one should use C for performing such operations
> > (http://osi.oracle.com/~tkyte/Misc/MoveLongs.html)
> > The problem is that I need to do it on a stored procedure.
> > Any suggestions?
> >
> > Thanks in advance.
> >
> > Anna Sotnichenko.
> >
> >
Received on Wed Dec 22 1999 - 23:12:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US