Re: sampling a table containing a LONG RAW field in a linked database using PL/SQL (ORACLE 7.3.4)

[Quoted] "François-Xavier de Montgolfier" <fdemontg_at_capgemini.fr.nospam> wrote in message news:3c0f50da.154727234_at_news.net.oleane.com...
> Hello,
> I'd like to have a way of emulating "insert into FOO from FOO_at_db1 F,
> TEMP t where f.id=t.id". Usually, I do it by using the DBMS_SQL
> package, and give the table name as an IN parameter of my procedure,
> but in this case it is not possible because LONG datatype cannot be
> part of a subquery for an insert statement.
>
> I know that a sql+ "COPY" statement would enable me to do this, but
> have to have a generic method of doing this.
>
> Is there a way of emulating the behaviour of "COPY" using PL/SQL ?

In short no. As you say you can use the copy command form sql*plus for longs [Quoted] (not sure it works with long raw though. If you want to do it programmatically its time to dig out that copy of Pro*C.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************