December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE [OR REPLACE] PACKAGEpackage_name[ AUTHID {CURRENT_USER | DEFINER} ] {IS | AS} [definitions of public TYPEs,declarations of public variables, types and objects,declarations of exceptions,pragmas,declarations of cursors, procedures and functions,headers of procedures and functions] END [package_name];
Lists all the objects that are publicly available for use in applications. A package specification also provides all the information a developer needs in order to use objects in the package; essentially, it is the package’s Application Programming Interface (API.). The package specification is required. A package does not need a body if the specification or that package does not contain any procedures or functions and if no private code is needed.