Mixing CMT and PL/SQL commit
843830Nov 8 2005 — edited Nov 9 2005Hi 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