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!

Intermittent ORA-29259 when calling utl_http.get_response (to SOAP Webservice)

Jose ArósteguiAug 21 2018 — edited Aug 22 2018

Hi experts,

I'm using PL/SQL in a Oracle Database 12c Enterprise Edition Release 12.1.0.2.0.

I'm calling every night a Webservice to retrieve VAT invoices from Spanish Agencia Tributaria (like the USA IRS -Internal Revenue Service-)

I'm getting some of the nights the error ORA-29259 when calling utl_http.get_response, I'd need some help in order to trace where the problem could be located:

  • Target host?
  • Local database host?
  • Proxy?

Particularly, the call which failed tonight returned 0 invoices so, I'm sure it isn't a problem due to XML sizes or similar.

Thanks in advance,

Jose.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2018
Added on Aug 21 2018
18 comments
2,490 views