Database Package Procedure Checks (PDM)

PowerDesigner provides default model checks to verify the validity of package procedures.

Check

Description and Correction

Package procedure name and code uniqueness

Database package procedure names and codes must be unique in the database package.

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/code

Package procedure definition empty

A package procedure must have a definition.

Manual correction: Create the package procedure definition in the Definition tab of the package procedure property sheet

Automatic correction: None

Existence of parameter

A package procedure must contain parameters for input and output values.

Manual correction: Create one or several parameters in the Parameters tab of the package procedure property sheet

Automatic correction: None

Check for undefined return types

If the package procedure is a function, you should define a return data type for the function.

Manual correction: Select a return data type in the Return Data Type list

Automatic correction: None