DBA Data[Home] [Help]

APPS.HXC_ALIAS_UTILITY dependencies on DBMS_SQL

Line 2954: c := dbms_sql.open_cursor ;

2950:
2951:
2952: END IF;
2953: -- test the SQL
2954: c := dbms_sql.open_cursor ;
2955: --##MS trap any exceptions raised here so that we can close the cursor before
2956: -- raising the error
2957: BEGIN
2958: dbms_sql.parse(c , l_stmt , dbms_sql.native) ;

Line 2958: dbms_sql.parse(c , l_stmt , dbms_sql.native) ;

2954: c := dbms_sql.open_cursor ;
2955: --##MS trap any exceptions raised here so that we can close the cursor before
2956: -- raising the error
2957: BEGIN
2958: dbms_sql.parse(c , l_stmt , dbms_sql.native) ;
2959: EXCEPTION
2960: WHEN OTHERS THEN
2961: dbms_sql.close_cursor(c);
2962: RAISE;

Line 2961: dbms_sql.close_cursor(c);

2957: BEGIN
2958: dbms_sql.parse(c , l_stmt , dbms_sql.native) ;
2959: EXCEPTION
2960: WHEN OTHERS THEN
2961: dbms_sql.close_cursor(c);
2962: RAISE;
2963: END;
2964:
2965: --##MS close cursor if the parse raised no exceptions

Line 2966: dbms_sql.close_cursor(c);

2962: RAISE;
2963: END;
2964:
2965: --##MS close cursor if the parse raised no exceptions
2966: dbms_sql.close_cursor(c);
2967:
2968: return (l_stmt);
2969:
2970: exception