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

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 - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

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

update : 27-04-2017

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

  • ora-38448 : Indexing predicates with "string" operator is not supported.
  • ora-12554 : TNS:current operation is still in progress
  • ora-30195 : reserved for future use
  • ora-02266 : unique/primary keys in table referenced by enabled foreign keys
  • ora-31651 : communication error with master process - detaching job
  • ora-23381 : generated object for base object string.string@string does not exist
  • ora-01299 : dictionary string corresponds to a different database incarnation
  • ora-13050 : unable to construct spatial object
  • ora-26674 : Column mismatch in 'string.string' (LCR: string type=string; DB: string type=string)
  • ora-02217 : duplicate storage option specification
  • ora-06311 : IPA: Maximum number of servers reached
  • ora-32842 : value for property string cannot be altered
  • ora-12982 : cannot drop column from a nested table
  • ora-33308 : (DBVALID04) SEVERE ERROR: Record number used but not allocated
  • ora-16710 : the resource guard is out of memory
  • ora-02181 : invalid option to ROLLBACK WORK
  • ora-32611 : incorrect use of MODEL CV operator
  • ora-27419 : unable to determine valid execution date from repeat interval
  • ora-29317 : datafile string does not exist
  • ora-31419 : source table string does not exist
  • ora-37180 : expected exactly one column for dimension string, got string
  • ora-36184 : (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
  • ora-07636 : smsdbp: $MGBLSC failure
  • ora-29298 : Character set mismatch
  • ora-08315 : sllfrb: Error reading file
  • ora-22628 : OCIAnyData already constructed
  • ora-30753 : column or table string is substitutable
  • ora-27154 : post/wait create failed
  • ora-29878 : warning in the execution of ODCIINDEXTRUNCATE routine
  • ora-13444 : GeoRaster metadata SRS error
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.