PowerDesigner provides default model checks to verify the validity of database package cursors, exceptions, procedures, types, and variables.
|
Check |
Description and Correction |
|---|---|
|
Package cursor name and code uniqueness |
Subobject 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 subobject definition empty |
[cursors, procedures, types] These subobjects must have a definition. Manual correction: Create the definition in the Definition tab of the subobject's property sheet Automatic correction: None |
|
Check for undefined return types |
[cursors, procedures] These subobjects must have a return data type. Manual correction: Select a return data type in the subobject's property sheet Automatic correction: None |
|
Existence of parameter |
[cursors, procedures] These subobjects must contain parameters for input values. Manual correction: Create one or several parameters in the Parameters tab of the subobject's property sheet Automatic correction: None |
|
Undefined data type |
[variables] Variables must have a data type. Manual correction: Select a data type in the variable property sheet Automatic correction: None |