Stored procedures routinely must set and detect null values. For example:

  • Stored procedures might need to set the values of SQL statement input parameters or procedure result fields to null.
  • Stored procedures must check if the value of a field in an SQL result set is null before assigning it through the SQLCursor.getValue method. The OpenEdge SQL Engine generates a run‑time error if the result‑set field specified in getValue is NULL.