Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Mixing CMT and PL/SQL commit

843830Nov 8 2005 — edited Nov 9 2005
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2005
Added on Nov 8 2005
1 comment
162 views