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!

PLS-00225: subprogram or cursor reference out of scoper - error

564814Jan 13 2012 — edited Jan 19 2012
I've a ProcedureA calling another procedureB. This procedure in inside a package packageB.I've an IF condition (inside Procedure A) to check for a variable "v_errmsg" value inside ProcedureB. The v_errmsg is declared as inside ProcedureB as below.
v_errmsg VARcHAR2(1000) := c_procname 
where c_procname is declared in PackageB body as
c_procname CONSTANT VARCHAR2(32) := 'pr_InitializeGlobalVariables';
My code looks like this
IF packageB.ProcedureB.v_errmsg is null then
...do something
else
... do something else
end if;
this gives an error PLS-00225: subprogram or cursor ProcedureB reference is out of scope.

Any suggestions on how the call to the variable should be is appreciated?

Edited by: steve2312 on Jan 13, 2012 9:01 AM
This post has been answered by Frank Kulash on Jan 13 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 16 2012
Added on Jan 13 2012
12 comments
5,463 views