This article explains how to execute multiple SQL statements using a single tOracleRow component rather than multiple components.
Procedure
-
Drop a tOracleRow component from the Palette to the design workspace.
-
Double-click tOracleRow and enter the below statements in the Query field:
"begin
update table1 set name='Shong' where id=2;
update table1 set name='Patrick' where id=3;
delete from table1 where id=4;
commit;
end;"
Note: The above example has only DML statements. If the group of SQL statements
contains DDL statements, type execute immediate
followed by the DDL statement. For example:
begin
update table1 set name='Shong' where id=2;
execute immediate 'drop table t3';
commit;
end;