ORA-06563: top level procedure/function specified, cannot have subparts
What triggered the Error:
The name to be resolved was specified with three parts (a.b.c) but the a.b part resolves to a top level procedure or function (which don't have nested procedures). This can also happen with a two-part name, a.b, where a is a synonym for a top level package or procedure.What should we do to fix it:
Specify a procedure/function within a package, or a top level procedure/function.