Re: Using the copy command in PL/SQL

As mentioned in another reply, you can't use COPY in DBMS_SQL because it is a SQL*Plus command, not a SQL command.

You could create a database link, define a cursor on the remote table, read through the cursor and insert into the local table, committing occassionally.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com