DBA Data[Home] [Help]

APPS.PER_SECURITY_PROFILES_PKG dependencies on DBMS_SQL

Line 549: l_cursor := dbms_sql.open_cursor;

545: -- This procedure was executing the SQL statement and affecting the
546: -- performance of 'Verify' custom SQL function in the Define Security
547: -- Profile form. The procedure is changed to parse the sql statement
548: -- instead of executing it.
549: l_cursor := dbms_sql.open_cursor;
550: dbms_sql.parse(l_cursor,l_sql_statement,dbms_sql.NATIVE);
551: return TRUE;
552:
553: EXCEPTION

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

546: -- performance of 'Verify' custom SQL function in the Define Security
547: -- Profile form. The procedure is changed to parse the sql statement
548: -- instead of executing it.
549: l_cursor := dbms_sql.open_cursor;
550: dbms_sql.parse(l_cursor,l_sql_statement,dbms_sql.NATIVE);
551: return TRUE;
552:
553: EXCEPTION
554: when others then