Home Oracle Commands

CREATE PACKAGE

Create a PL/SQL stored package.

Syntax:

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

invoker_rights:  
      AUTHID CURRENT_USER
      AUTHID DEFINER

AUTHID DEFINER will execute with the privileges of the package schema/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 




Back to the Top

Simon Sheppard
SS64.com