Oracle Package Header
LeasePak Documentation Suite NETSOL website
Home Search Help
End User Code Objects

End User Code Objects

Oracle Package Header

Previous  Next

The following are the required programming constructs for an Oracle package file:

 
Whenever Sqlerror Exit Failure Rollback 
Whenever Oserror  Exit Failure Rollback 
 
CREATE OR REPLACE PACKAGE upkg_package-name 
AS 
    procedure and function prototypes 
END upkg_package-name; 
 
CREATE OR REPLACE PACKAGE BODY upkg_package-name 
AS 
    procedure and function definitions 
END upkg_package-name; 
\ 
Exit

And for an Oracle procedure file:

 
Whenever Sqlerror Exit Failure Rollback 
Whenever Oserror  Exit Failure Rollback 
 
CREATE OR REPLACE PROCEDURE cp_procedure-name 
    procedure definiton 
END cp_procedure-name; 
\ 
Exit