CAN USE COPY COMMAND INSIDE PROCEDURE BODY
Hi all
can we use COPY command inside procedure body like this
CREATE OR REPLACE procedure USER2.PRO1
Begin
execute immediate'copy from hr/hr@ERP to USER21/PASS@DB1 append user2.per_images using select * from hr.per_images';
commit;
end;
/
YOU ADVICE PLEASE
can we use COPY command inside procedure body like this
CREATE OR REPLACE procedure USER2.PRO1
Begin
execute immediate'copy from hr/hr@ERP to USER21/PASS@DB1 append user2.per_images using select * from hr.per_images';
commit;
end;
/
YOU ADVICE PLEASE
0