Calling a Static Procedure from a Member Procedure Results in PLS-00225 During Compilation of the Object Type Body
(Doc ID 1294890.1)
Last updated on FEBRUARY 24, 2019
Applies to:PL/SQL - Version 184.108.40.206 and later
Information in this document applies to any platform.
Calling a static procedure from a member procedure fails during compilation of the object type body with:
PLS-00225: subprogram or cursor 'OBJTYPENAME' reference is out of scope
The following test case scenario demonstrates the issue:
create type objType as object
static procedure staticProc,
constructor function objType(
self in out noCopy objType)
return self as result,
member procedure memberProc
create type body objType as
static procedure staticProc is
constructor function objType(self in out noCopy objType) return self as result is
self.num := 0;
member procedure memberProc is
PLS-00225: subprogram or cursor 'OBJTYPE' reference is out of scope
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document