Re: dynamic script's

[Larry Meadors]

This works perfectly in Oracle:

<delete id="delete">
 BEGIN
   DELETE FROM Child WHERE childId = #parentId#;
   DELETE FROM Parent WHERE parentId = #parentId#;
 END;
</delete>

It is a single prepared statement, and performs great.

Larry


On 8/23/06, Daniel Pitts <[EMAIL PROTECTED]> wrote:

Is there a way to run an SQL "script" from iBATIS?
Such as:
INSERT INTO foo (#bar#, #baz#);
INSERT INTO ho (#hum#);


Also, if there is, is it possible to dynamically generate the SQL to do
so?
Eg:
INSERT INTO foo (#bar#, #baz#);
<iterate property="hos">INSERT INTO ho (#bar#, #hos[]#);</iterate>

Thanks.