The following PDM model checks are made on 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 |