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 |