SQL%isopen

[farrokhp]

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

[marist89]

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.