Database Package Cursor Checks (PDM)

The following PDM model checks are made on package cursors:

Check

Description and Correction

Package cursor name and code uniqueness

Database package cursor 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 cursor definition empty

A package cursor must have a definition.

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

Automatic correction: None

Check for undefined return types

You should define a return data type for a cursor.

Manual correction: Select a return data type in the cursor property sheet

Automatic correction: None

Existence of parameter

A cursor must contain parameters for input values.

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

Automatic correction: None


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com