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.

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.

Parent topic: Database Packages