Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to copy LONG RAW data?
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 - 21:11:55 CST