Hi,
I have a requirement where i want to copy the data of some tables of
one user to tables of another user. So I want to create a procedure
having two parameter *sourceUser* and *targetUser.* But when I am trying
to compile that procedure it gives following error :

LINE/COL ERROR
--------
-----------------------------------------------------------------
3/1 PL/SQL: SQL Statement ignored
3/59 PL/SQL: ORA-00942: table or view does not exist


* My procedure is like this :*

create or replace procedure copyTables (sourceUser in varchar2,
targetUser in varchar2) is
begin
insert into targetUser.tableA select * from sourceUser.tableB;
end;
/

Any idea about how to solve this ?
Thanks

Rajesh

Oracle LazyDBA home page