Skip to content

Hints on cursors

Invalid condition in WHERE clause

Editor provides errors for common typing mistakes in cursor where clause, such as <column> <operator> <column> where operator can be �=�, �!=�, �<>�, �>=�, �>�, �<=�, �<�.

Example of Incorrect Code:

CURSOR get_allocations IS ������  
    SELECT * ������  
    FROM &TAB_MAT_ALLOC ������  
    WHERE sequence_no = sequence_no�����  
    AND (qty_required - qty_issued) > 0;  

Example of Correct Code:

CURSOR get_allocations IS ������  
    SELECT * ������  
    FROM &TAB_MAT_ALLOC ������  
    WHERE sequence_no = sequence_no_�����  
    AND (qty_required - qty_issued) > 0;  

Actions Available:

  • Add an IgnoreCursorWhereClause.