729:
730: FUNCTION check_proc (p_rule_id NUMBER) RETURN BOOLEAN IS
731: c NUMBER;
732: BEGIN
733: c := dbms_sql.open_cursor;
734: dbms_sql.parse(c,replace(l_sql,'RULEID',to_char(p_rule_id)),2);
735: dbms_sql.close_cursor(c);
736: RETURN TRUE;
737: EXCEPTION
730: FUNCTION check_proc (p_rule_id NUMBER) RETURN BOOLEAN IS
731: c NUMBER;
732: BEGIN
733: c := dbms_sql.open_cursor;
734: dbms_sql.parse(c,replace(l_sql,'RULEID',to_char(p_rule_id)),2);
735: dbms_sql.close_cursor(c);
736: RETURN TRUE;
737: EXCEPTION
738: WHEN OTHERS THEN
731: c NUMBER;
732: BEGIN
733: c := dbms_sql.open_cursor;
734: dbms_sql.parse(c,replace(l_sql,'RULEID',to_char(p_rule_id)),2);
735: dbms_sql.close_cursor(c);
736: RETURN TRUE;
737: EXCEPTION
738: WHEN OTHERS THEN
739: RETURN FALSE;
12806: n NUMBER;
12807: l_custom BOOLEAN;
12808:
12809: BEGIN
12810: c := dbms_sql.open_cursor;
12811: l_sql := 'select ' || proc ||
12812: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12813: dbms_sql.parse(c,l_sql,2);
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12809: BEGIN
12810: c := dbms_sql.open_cursor;
12811: l_sql := 'select ' || proc ||
12812: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12813: dbms_sql.parse(c,l_sql,2);
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12810: c := dbms_sql.open_cursor;
12811: l_sql := 'select ' || proc ||
12812: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12813: dbms_sql.parse(c,l_sql,2);
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12811: l_sql := 'select ' || proc ||
12812: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12813: dbms_sql.parse(c,l_sql,2);
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12819: n:=DBMS_SQL.execute(c);
12812: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12813: dbms_sql.parse(c,l_sql,2);
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12819: n:=DBMS_SQL.execute(c);
12820: dbms_sql.close_cursor(c);
12813: dbms_sql.parse(c,l_sql,2);
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12819: n:=DBMS_SQL.execute(c);
12820: dbms_sql.close_cursor(c);
12821: RETURN TRUE;
12814: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12819: n:=DBMS_SQL.execute(c);
12820: dbms_sql.close_cursor(c);
12821: RETURN TRUE;
12822: EXCEPTION
12815: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12819: n:=DBMS_SQL.execute(c);
12820: dbms_sql.close_cursor(c);
12821: RETURN TRUE;
12822: EXCEPTION
12823: WHEN OTHERS THEN
12816: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12817: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12818: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12819: n:=DBMS_SQL.execute(c);
12820: dbms_sql.close_cursor(c);
12821: RETURN TRUE;
12822: EXCEPTION
12823: WHEN OTHERS THEN
12824: dbms_sql.close_cursor(c);
12820: dbms_sql.close_cursor(c);
12821: RETURN TRUE;
12822: EXCEPTION
12823: WHEN OTHERS THEN
12824: dbms_sql.close_cursor(c);
12825: RETURN FALSE;
12826: END;
12827:
12828: --VJN Introduced for Bulk Match Rules