|
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