Re: Oracle Trigger

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1075838987.737966_at_yasure...
| Mark C. Stock wrote:
|
| > Can you elaborate on why the generalization that dynamic SQL is required
for
| > creating triggers?
| >
| > -- mcs
|
| DDL can not be performed using PL/SQL ... for example you can't even do
| this:
|
| BEGIN
| TRUNCATE TABLE my_table;
| END;
| /
|
| What you must do is:
|
| BEGIN
| EXECUTE IMMEDIATE 'TRUNCATE TABLE my_table';
| END;
| /
|
| Same rule applies to creating triggers.
| --
| Daniel Morgan
| http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
| http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
| damorgan_at_x.washington.edu
| (replace 'x' with a 'u' to reply)
|

that's well known when using PL/SQL, but that was not so in the OP's case -- he was not using PL/SQL, but submitting SQL statements via JDBC.

so there is absolutely no need to do anything other than submit a properly formed DDL statement.

• mcs