Oracle Error Message
ORA-06563: name has too many parts
Reason for the Error
The name to be resolved was specified as one of the following:
– With three parts (A.B.C) but the A.B parts resolved to an object that did not expose visible nested procedures; the C part could not be resolved.
– With two parts (A.B) and the A part resolved to an object that did not expose visible nested procedures; the B part could not be resolved.
Solution
Specify the valid name of an object or of a packaged procedure or function without specifying any additional trailing parts.