SQL>
SQL> CREATE OR REPLACE PROCEDURE closecur (cur_in IN INTEGER)
2 IS
3 BEGIN
4
5 IF DBMS_SQL.IS_OPEN (cur_in);
6
7 THEN
8
9 DBMS_SQL.CLOSE_CURSOR (cur_in);
10
11 END IF;
12 END;
13 /
Warning: Procedure created with compilation errors.
SQL>