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

tech_usrJul 24 2006 — edited Jul 24 2006

Hi,

I'm trying to invoke a stored procedure from my application and the stored procedure is on a remote database. I've the TNSnames and a user-id that has execute privileges on this stored procedure. But I'm getting following error message -

Java.sql.SQLException:
ORA-02089: COMMIT is not allowed in a subordinate session

When I invoke the stored procedure from a JSP that directly invokes my JDBC call, I do not receive the above error. Does anyone who what is the root cause of this problem? Has it got anything to do with the application server settings or the remote database configuration?

Any inputs will be appreciated.
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 21 2006

Added on Jul 24 2006

2 comments

632 views