Generating database packages

Chapter 12 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.

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 the DBMS Resource File Reference chapter in the Customizing and Extending PowerDesigner manual.