Re: utl_http packages gives undefined exception

dontreply_tdykstra_at_cfol.ab.ca (Terry Dykstra) wrote in <WWoC5.12507$24.2354101_at_news0.telusplanet.net>:

[snip]
>and it gives me error:
>ORA-06510: PL/SQL: unhandled user-defined exception
>ORA-06512: at "SYS.UTL_HTTP", line 152
>ORA-06512: at line 1
>Any ideas what could be the cause?

The 'unhandled exceptions' are defined in the utl_http package, but must be explicitly handled within a package to avoid displaying the generic errors you describe.

INIT_FAILED is raised for http-callout subsystem failures; REQUEST_FAILED is raised for http call failures (e.g. bad URL, etc.)

A quick way to test which one it is from SQL*Plus:

DECLARE
   tst VARCHAR2(2000);
BEGIN

• give 'tst' a dummy URL to look for tst := UTL_HTTP.REQUEST('http://www.orakel.com');
• substr first 255 chars out for display, to avoid
• blowing up SQL*Plus DBMS_OUTPUT.PUT_LINE(substr(tst,1,255)); EXCEPTION WHEN utl_http.init_failed THEN dbms_output.put_line('init fail'); WHEN utl_http.request_failed THEN dbms_output.put_line('request fail'); WHEN others THEN dbms_output.put_line('something else is broken...'); END; /

Some possibilities:

• Is your Oracle server behind a proxy? If so, the proxy's address needs to be passed to the function (e.g. utl_http.request('http://foo.com','myProxy')
• Have you tried resolving an address by IP, instead of by name?

There are probably better ways to figure this out; I'm far from an expert, this has just been my experience.

HTH...

-- 
Rev. WarFrost
-------------
"The Net interprets censorship as damage and routes around it."
- John Gilmore

"And who is a serpent among us? Anyone who would strike a child."
- Kurt Vonnegut, Jr.

"We want things to be easier. How badly we want it can be
 measured by the size of Bill Gates's fortune."
- Neal Stephenson, 'In the Beginning was the Command Line'