Forum Stats

  • 3,874,103 Users
  • 2,266,679 Discussions
  • 7,911,727 Comments

Discussions

sys.utl_http stopped working in batch; still works in APEX?

NancyKay
NancyKay Member Posts: 11 Blue Ribbon

We have a package in Oracle 11gR1 that runs a nightly "job" to produce reports; it is designed to call the Oracle Reports server via URL and create a report as pdf, then save it to a directory in the Oracle LINUX filesystem. The call in the output procedure is simple:

           MY_URL :=

'http://refugee1.dcf.state.fl.us:7777/reports/rwservlet?server=repRefugeeTest&report=DELIVERABLE_RPT.rdf&destype=FILE&desformat=pdf&userid=ruser/[email protected]&desname=/app/oracle/external_files/official_reports/MAY_2014_DELIV.pdf&contract=XK030&report_beg_d=05/01/2014&report_end_d=05/31/2014&subc=&sticker=OFFICIAL REPORT';

            UTL_HTTP.SET_TRANSFER_TIMEOUT (180);

            MY_HTTP_RTN := UTL_HTTP.REQUEST (MY_URL);

            UTL_HTTP.SET_TRANSFER_TIMEOUT (60);

This Oracle package has worked for years with user RPD, until we moved up some rdf and report package changes yesterday.  These same four commands still work fine using APEX (with user APEX_PUBLIC_USER) in a windows-based browser (Firefox and IE), but this command UTL_HTTP.REQUEST does not produce output anymore from the Oracle package (with user RPD) and throws no exception.  There is no job in the Oracle Reports queue (exception or not) to show that the request was passed.  And, if I paste the string of MY_URL into a windows-browser, then it runs and Oracle Reports shows the job.  I'm stumped!  Please help shed light on the mystery; how can I trace or trap what's (not) happening?

This discussion has been closed.