Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> :new in Dynamic sql
CREATE TRIGGER ......
....
DECLARE
CURSOR cur IN SELECT column_name FROM user_tab_cols WHERE table_name =
ora_dict_obj_name;
sQuery VARCHAR2(1000);
BEGIN
FOR data IN cur LOOP
-- double single quote in UPDATE text
sQuery := 'INSERT INTO auditor_table VALUES (' || ':NEW.' ||
data.column_name || ', :OLD.' || data.column_name || ', ''UPDATE'')';
EXECUTE IMMEDIATE sQuery;
END LOOP;
END;
I am getting below error:
"Not all the variable are bound"
Oracle is treating :NEW as a find variable and throwing error, Please
advice.
Received on Fri May 25 2007 - 09:59:48 CDT