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

[Quoted] On Fri, 7 Dec 2001 09:37:14 -0000, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:

>"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
>(not sure it works with long raw though.

You can't :-) I found the info shortly after posting this...

>If you want to do it
>programmatically its time to dig out that copy of Pro*C.

I was afraid of this... Not that I dislike Pro/C, but I'm not going to be the one maintaining it after.

Nonetheless, thanks for the info!

François-Xavier Received on Fri Dec 07 2001 - 14:20:13 CET