Generating database packages

Chapter 15 DBMS-Specific Features

Generating database packages

You can define generation parameters for database packages in the Database Package tab of the Triggers and Procedures Generation dialog box. This tab is displayed when the current DBMS belongs to the Oracle family.

The following parameters are available:

Parameter	Resulting generation command
Create database package	Create database package, as defined in the Oracle DBMS: create package %DBPACKAGE% [authid %DBPACKAGEPRIV% ][[%R%?[is][as]:as] %DBPACKAGESPEC% end [%DBPACKAGE%]/ [create package body %DBPACKAGE% AS %DBPACKAGEBODY% [BEGIN %DBPACKAGEINIT%] ] end [%DBPACKAGE%] ]
Drop database package	Drop database package, as defined in the Oracle DBMS: drop package %DBPACKAGE%
Permission	Generate the permission statement for a given user during database package creation.

Parameter

Resulting generation command

Create database package

Create database package, as defined in the Oracle DBMS:

create package %DBPACKAGE% [authid %DBPACKAGEPRIV% ][[%R%?[is][as]:as]

%DBPACKAGESPEC%

end [%DBPACKAGE%]/

[create package body %DBPACKAGE% AS

%DBPACKAGEBODY%

[BEGIN

%DBPACKAGEINIT%] ]

end [%DBPACKAGE%]

Drop database package

Drop database package, as defined in the Oracle DBMS:

drop package %DBPACKAGE%

Permission

Generate the permission statement for a given user during database package creation.

For more information on the create and drop statements for database packages, see chapter DBMS Reference Guide in the Advanced User Documentation .