1056: -----------------------------------------------------------------------------
1057: PROCEDURE close_cursor( p_cursor_handle IN OUT NOCOPY NUMBER ) IS
1058: BEGIN
1059:
1060: IF( dbms_sql.is_open( p_cursor_handle ) ) THEN
1061: dbms_sql.close_cursor( p_cursor_handle );
1062: END IF;
1063:
1064: EXCEPTION
1057: PROCEDURE close_cursor( p_cursor_handle IN OUT NOCOPY NUMBER ) IS
1058: BEGIN
1059:
1060: IF( dbms_sql.is_open( p_cursor_handle ) ) THEN
1061: dbms_sql.close_cursor( p_cursor_handle );
1062: END IF;
1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN