Dynamical generating of Oracle triggers problem
Date: 1999/07/19
Message-ID: <7mvjet$pic$1_at_nclient3-gui.server.ntli.net>#1/1
Dear Sir,
I have been using the dynamical generating of Oracle triggers utilising
DBMS_SQL package on Oracle 7.3.3. I have found that on Oracle 8.1.5 my
trigger creating code stopped working. Is there any way to make it working?
Connected to:
SQL> declare
PL/SQL procedure successfully completed.
SQL>
Connected to:
SQL> declare
Oracle7 Server Release 7.3.3.0.0 - Production Release
With the distributed option
PL/SQL Release 2.3.3.0.0 - Production
2 cursordesc integer;
3 resultdesc integer;
4 begin
5 cursordesc := dbms_sql.open_cursor;
6 dbms_sql.parse(cursordesc,'create or replace trigger
test_beforeinsert before insert on test for each row begin null;
end',dbms_sql.v7);
7 resultdesc := dbms_sql.execute(cursordesc);
8 dbms_sql.close_cursor(cursordesc);
9 end;
10 /
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
2 cursordesc integer;
3 resultdesc integer;
5 cursordesc := dbms_sql.open_cursor;
6 dbms_sql.parse(cursordesc,'create or replace trigger
test_beforeinsert before insert on test for each row begin null;
end',dbms_sql.v7);
7 resultdesc := dbms_sql.execute(cursordesc);
8 dbms_sql.close_cursor(cursordesc);
9 end;
10 /
ERROR:
ORA-24344: success with compilation error ORA-06512: at "SYS.DBMS_SYS_SQL", line 487 ORA-06512: at "SYS.DBMS_SQL", line 32 ORA-06512: at line 6
SQL>
Thank you,
Alex.
Received on Mon Jul 19 1999 - 00:00:00 CEST