Back to Index |

Sending multiple SQL statements to Oracle in the Pre and Post DML properties

Sending multiple SQL statements to Oracle requires that they are wrapped in a PL/SQL block using BEGIN and END;

For instance; the following code is first truncating a table, then running an update statement on a different table:

BEGIN

dbms_utility.exec_ddl_statement('truncate table MY_WORK_TABLE');

update MyTable set TheDate = sysdate where TheDate IS NULL;

commit;

END;

© 2003 - 2007 Relational Solutions, Inc. - All rights reserved