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;
12750: n NUMBER;
12751: l_custom BOOLEAN;
12752:
12753: BEGIN
12754: c := dbms_sql.open_cursor;
12755: l_sql := 'select ' || proc ||
12756: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12757: dbms_sql.parse(c,l_sql,2);
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12753: BEGIN
12754: c := dbms_sql.open_cursor;
12755: l_sql := 'select ' || proc ||
12756: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12757: dbms_sql.parse(c,l_sql,2);
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12754: c := dbms_sql.open_cursor;
12755: l_sql := 'select ' || proc ||
12756: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12757: dbms_sql.parse(c,l_sql,2);
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12755: l_sql := 'select ' || proc ||
12756: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12757: dbms_sql.parse(c,l_sql,2);
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12763: n:=DBMS_SQL.execute(c);
12756: '(:attrval,:lang,:attr,:entity,:ctx) from dual';
12757: dbms_sql.parse(c,l_sql,2);
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12763: n:=DBMS_SQL.execute(c);
12764: dbms_sql.close_cursor(c);
12757: dbms_sql.parse(c,l_sql,2);
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12763: n:=DBMS_SQL.execute(c);
12764: dbms_sql.close_cursor(c);
12765: RETURN TRUE;
12758: DBMS_SQL.BIND_VARIABLE(c,':attrval','x');
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12763: n:=DBMS_SQL.execute(c);
12764: dbms_sql.close_cursor(c);
12765: RETURN TRUE;
12766: EXCEPTION
12759: DBMS_SQL.BIND_VARIABLE(c,':lang','x');
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12763: n:=DBMS_SQL.execute(c);
12764: dbms_sql.close_cursor(c);
12765: RETURN TRUE;
12766: EXCEPTION
12767: WHEN OTHERS THEN
12760: DBMS_SQL.BIND_VARIABLE(c,':attr','x');
12761: DBMS_SQL.BIND_VARIABLE(c,':entity','x');
12762: DBMS_SQL.BIND_VARIABLE(c,':ctx','x');
12763: n:=DBMS_SQL.execute(c);
12764: dbms_sql.close_cursor(c);
12765: RETURN TRUE;
12766: EXCEPTION
12767: WHEN OTHERS THEN
12768: dbms_sql.close_cursor(c);
12764: dbms_sql.close_cursor(c);
12765: RETURN TRUE;
12766: EXCEPTION
12767: WHEN OTHERS THEN
12768: dbms_sql.close_cursor(c);
12769: RETURN FALSE;
12770: END;
12771:
12772: --VJN Introduced for Bulk Match Rules