CREATE PACKAGE / PACKAGE BODY

Create a PL/SQL stored package.

Syntax:

   CREATE [OR REPLACE] PACKAGE [schema.]package_name [invoker_rights] AS package

   CREATE [OR REPLACE] PACKAGE BODY [schema.]package_name AS plsql_package_body

   invoker_rights:  
      AUTHID CURRENT_USER
      AUTHID DEFINER

AUTHID DEFINER will cause the package to execute with the privileges of the package owner.

"If you have built castles in the air, your work need not be lost...put foundations under them" - Henry David Thoreau

Related Commands:

ALTER PACKAGE
DROP PACKAGE

Related Views:

 CODE_PIECES
 CODE_SIZE
 DBA_SOURCE      ALL_SOURCE      USER_SOURCE