Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-30563: outer join operator (+) not allowed in select-list

1 Answers  


RMAN-06735: Do you really want to drop the database (enter YES or NO)?

1 Answers  


ORA-19005: Duplicate XMLType LOB storage option

1 Answers  


ORA-13200: internal error [string] in spatial indexing.

1 Answers  


ORA-16074: ARCH processes must be active

1 Answers  






ORA-32631: illegal use of objects in MODEL

1 Answers  


ORA-33278: (DBERR09) Analytic workspace string cannot be attached in RW or EXCLUSIVE mode until the changes made and updated in MULTI mode are committed or rolled back.

1 Answers  


ORA-12046: cannot use trusted constraints for refreshing remote MV

1 Answers  


PLS-00110: bind variable 'string' not allowed in this context

1 Answers  


NNC-00412: invalid name "string"

1 Answers  


ORA-01671: controlfile is a backup, cannot make a standby controlfile

1 Answers  


ORA-28670: mapping table cannot be dropped due to an existing bitmap index

1 Answers  






Categories