Mixing CMT and PL/SQL commit

Hi there,

I've been looking through some code here, and I have a question regarding the use of CMT and PL/SQL.

Basically, we have a stateless session bean that calls a DAO, which in turn executes a PL/SQL procedure.

Halfway through the PL/SQL procedure, a COMMIT is called, on a global temporary table.

Surely this breaks the ability of the bean to successfully roll back all information? Or is this something special because its a tempoary table?

Thanks, Neil

[498 byte] By [neil_laurancea] at [2007-10-2 4:35:43]