If you want to use Data Manipulation Language (DML) or Data Definition Language
(DDL) in your PL/SQL, you can use the SRW.DO_SQL
built-in procedure. Note that SRW.DO_SQL
should only be used for
DML and DDL; you should not use it to fetch data. For more information on DML
and DDL, see the Oracle Server SQL Language Reference manual.
Because of Oracle Reports' processing model, it is recommended that you only use DDL in the Before Parameter Form and After Parameter Form triggers. DML can be entered any place that accepts PL/SQL.
Any DML or DDL that will reported on with this report's processing should be done in (or before) the After Parameter Form trigger. Consistency nondefault be guaranteed in the Before Report trigger, since Oracle Reports may have to start some work on data cursors before that trigger based on the definition of the report. One thing Reports Builder always does before the Before Report trigger is to describe the tables involved and open cursors. Any change to the tables after that will not be seen by the report.
Note: The use of SRW.DO_SQL
adds some overhead
to the running of the report.
Copyright © 1984, 2005, Oracle. All rights reserved.