DBA Data[Home] [Help]

APPS.PER_SECURITY_PROFILES_PKG dependencies on DBMS_SQL

Line 593: l_cursor := dbms_sql.open_cursor;

589: -- This procedure was executing the SQL statement and affecting the
590: -- performance of 'Verify' custom SQL function in the Define Security
591: -- Profile form. The procedure is changed to parse the sql statement
592: -- instead of executing it.
593: l_cursor := dbms_sql.open_cursor;
594: dbms_sql.parse(l_cursor,l_sql_statement,dbms_sql.NATIVE);
595: return TRUE;
596:
597: EXCEPTION

Line 594: dbms_sql.parse(l_cursor,l_sql_statement,dbms_sql.NATIVE);

590: -- performance of 'Verify' custom SQL function in the Define Security
591: -- Profile form. The procedure is changed to parse the sql statement
592: -- instead of executing it.
593: l_cursor := dbms_sql.open_cursor;
594: dbms_sql.parse(l_cursor,l_sql_statement,dbms_sql.NATIVE);
595: return TRUE;
596:
597: EXCEPTION
598: when others then