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!

Stored procedure did not work with pragma autonomous_transaction

user11141511Feb 17 2016 — edited Feb 19 2016

Hello All,

I wrote some stored procedures with "pragma autonomous_transaction" ,

but when these stored procedures invoked via a Fusion Middleware

pragma autonomous was thoroughgoing "ora-02089" error. 

Why fusion process was prompting that error?

Regards,

Vani
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2016
Added on Feb 17 2016
7 comments
1,802 views