Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

calling a procedure that exist in another schema

976759Nov 28 2012 — edited Nov 28 2012
hello , i need your help .

i would like to know how i can call a procedure that exist in another schema

what i did for example calling the procedure "proc" at schema "user1" from pl/sql code

begin
user1.proc(parm1,parm2);
end;

i got the error message

(1): PLS-00201: identifier 'user1.proc' must be declared
(2): PL/SQL: Statement ignored

but by calling it from SQL PLUS from the same current schema i got no errors

exec user1.proc(parm1,parm2);

thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2012
Added on Nov 28 2012
3 comments
10,303 views