No. You can’t execute the package as a whole; it’s simply a container for other PL/SQL elements. You can execute procedures and functions defined in the package specification, as well as reference data structures defined in a package specification (a constant, variable, exception, etc.).
You would use dot notation, in the form of package.element, as in:
You don’t need to qualify a package element with its package name under these circumstances:
This table explains the use of the packaged elements in this code:
The STANDARD package contains the definitions of many of the elements of the PL/SQL language, including datatypes, exceptions, and functions. DBMS_STANDARD contains database-related programs, including COMMIT, ROLLBACK, and RAISE_APPLICATION_ERROR. They are the defaults, so dot notation is not required.
Any data structure declared in a package specification ...