-
Consider this PL/SQL block :
DECLARE
v_result BOOLEAN;
BEGIN
DELETE
FROM product
WHERE product_id IN (25, 35, 45);
v_result := SQL%ISOPEN;
COMMIT;
END;
What would be the value of v_result if let's say three rows detected?
TRUE, FALSE, NULL, Zero or ... ?
Thanks
-
Since a DELETE statement opens an implicit cursor, the value would be FALSE. An implicit cursor opens a cursor when the statement starts and closes the cursor when the statement ends. By the time you get to assign SQL%ISOPEN to v_result, it will already be closed.