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!

Using UTL_HTTP is Transaction Control possible

758149Mar 28 2013 — edited Mar 28 2013

Hi All,

I am new to this UTL_HTTP too. I am trying to access a Webservice from my PL/SQL and the webservice intern calls a procedure from a different system.
Can this transaction controlled from my PL/SQL Block?

I mean, If I issue a Commit in my PL/SQL code, the COMMIT should happen in the 2nd system too.
Same way the rollback.

Is it possible? If so, How it works? any example you got.

Thanks a lot for your help guys!!

Best Regards,
Sivakumar M

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 25 2013

Added on Mar 28 2013

#control, #transaction

4 comments

532 views