ORA-06563: top level procedure/function specified, cannot
have subparts



ORA-06563: top level procedure/function specified, cannot have subparts..

Answer / guest

Cause: 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.

Action: Specify a procedure/function within a package, or a
top level procedure/function.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02065: illegal option for ALTER SYSTEM

1 Answers  


ORA-26052: Unsupported type number for SQL expression on column string.

1 Answers  


ORA-13826: empty SQL profile not allowed for create or update SQL profile

1 Answers  


NZE-29151: 3DES self-test failure

1 Answers  


QSM-01123: self-join algorithm could not resolve multiple instances

1 Answers  






ORA-30772: opaque types do not have default constructors

1 Answers  


ORA-25236: buffer too small for user data

1 Answers  


PLS-00205: Aggregate not allowed here

1 Answers  


SQL*Loader-00559: error closing file

1 Answers  


ORA-30026: Undo tablespace 'string' has unexpired undo with string(sec) left, Undo_Retention=string(sec)

1 Answers  


ORA-01193: file string is not the same file seen at start of recovery

1 Answers  


RMAN-03023: executing command: string

1 Answers  


Categories