1115: -----------------------------------------------------------------------------
1116: PROCEDURE close_cursor( p_cursor_handle IN OUT NOCOPY NUMBER ) IS
1117: BEGIN
1118:
1119: IF( dbms_sql.is_open( p_cursor_handle ) ) THEN
1120: dbms_sql.close_cursor( p_cursor_handle );
1121: END IF;
1122:
1123: EXCEPTION
1116: PROCEDURE close_cursor( p_cursor_handle IN OUT NOCOPY NUMBER ) IS
1117: BEGIN
1118:
1119: IF( dbms_sql.is_open( p_cursor_handle ) ) THEN
1120: dbms_sql.close_cursor( p_cursor_handle );
1121: END IF;
1122:
1123: EXCEPTION
1124: WHEN OTHERS THEN