Try OpenEdge Now
skip to main content
SQL Development
Stored Procedures and Triggers : Writing stored procedures : Using the OpenEdge SQL Java classes : Handling null values
 
Handling null values
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.