Ouch. That's quite a unique requirement. The biggest problem will be that iBATIS exclusively uses PreparedStatements (for performance and security reasons).
So the first step would be to check to see if you can run DML within a Prepared statement. After that, we can start to explore whether this can be done at all.
Cheers,
Clinton
On 7/21/05, Mississippi John Hurt <[EMAIL PROTECTED]> wrote:
Hi,
I need to encapsulate some DML (such as ALTER TABLE DISABLE CONSTRAINT) as well as a long anonymous PL/SQL block of code (not compiled in the database) in Java objects. Can I do this with iBatis? If so how? From what I understand iBatis can only map SQL and a single stored procedure. How would I map say, something like a script with DML (ALTER TABLE) followed by a block of anonymous PL/SQL? Thanks.
