Hi DBA Gurus,
Is it possible to use the copy command in a stored procedure? I am trying
to use the copy command to copy one of the table data from user A to user B
in the same database in a stored procedure with source database, username
and password and destination database, username and password being used as
input parameters. But I am getting ora - 900 error - invalid sql statement
error. Any ideas?
Here is my code:
create or replace procedure copy_proc as
sql1 varchar2(2000);
begin
sql1:= 'copy from primal/primal@primal to jstage2/jstage2@primal append
carrier using select * from carrier';
execute immediate sql1;
end;
Any help in this regard will be very much appreciated.
TIA and Regards,
Ranganath
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ranganath K
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
