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