Q. Write PL/SQL Block For Exception Of CURSOR_ALREADY_OPEN.
Output:
DECLARE
CURSOR emp_cur IS SELECT * FROM emp;
BEGIN
OPEN emp_cur;
OPEN emp_cur;
EXCEPTION
WHEN CURSOR_ALREADY_OPEN THEN
DBMS_OUTPUT.PUT_LINE('The Cursor Is Already Opened !');
END;
/
The Cursor Is Already Opened !
PL/SQL procedure successfully completed.
Compatibility (Tested on):
Oracle Database 10g Express Edition Release 10.2.0.1.0 – Product
