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 release_no = release_no_
AND order_no = order_no_
AND qty_per_assembly <> 0
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 release_no = release_no_
AND order_no = order_no_
AND qty_per_assembly <> 0
AND (qty_required - qty_issued) > 0;
Here sequence_no_ is a method parameter.
Actions Available: