Skip to Main Content
Forums

SQL & PL/SQL

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!

ORA-02089: COMMIT is not allowed in a subordinate session

user569602Apr 16 2007 — edited Apr 16 2007
Here is my configuration.
jdbc driver:10.2.0.3.0
EJB-CMP

Am using oracle.jdbc.xa.client.OracleXADataSource as the driver in my websphere application server 6.0.0.1.

when i am calling a stored procedure from my EJB and in the stored procedure if
i perform any DDL operation like truncate a table,create a table or commit it throws the exception:-
ORA-02089: COMMIT is not allowed in a subordinate session

please help me in solving this issue asap.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2007
Added on Apr 16 2007
2 comments
564 views