Home » Developer & Programmer » JDeveloper, Java & XML » ORA-29273, ORA-06512, ORA-29269: HTTP server error 500 - Internal Server in a Web Service PL/SQL (Oracle 11g PL/SQL, Red Hat Linux)
ORA-29273, ORA-06512, ORA-29269: HTTP server error 500 - Internal Server in a Web Service PL/SQL [message #641776] Sat, 22 August 2015 14:22 Go to next message
anuarcastillo
Messages: 1
Registered: August 2015
Location: Bogotá, Colombia
Junior Member
I'm trying to consume a web service using this code:

declare
t_request utl_http.req; -- Request
t_response utl_http.resp; -- Response
t_informacion_soap varchar2(32767); -- Información SOAP que se enviará para consumir el WS
t_dir_web constant varchar2(2000):= 'http://192.168.xxx.xx/...';
begin
t_informacion_soap :=
'<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" ....
.................
</soapenv:Envelope>';
--
utl_http.set_response_error_check(true);
t_request := utl_http.begin_request(t_dir_web,'POST',utl_http.http_version_1_1);
utl_http.set_header(t_request, 'Content-Type', 'text/xml; charset=utf-8');
utl_http.set_header(t_request, 'SOAPAction', 'http://tempuri.org/ImportarXML');
--
utl_http.set_header(t_request, 'Content-Length', length(t_informacion_soap));
--
utl_http.write_text(t_request, t_informacion_soap);
t_response := utl_http.get_response(t_request);
exception
when others then
dbms_output.put_line('Error: '||dbms_utility.format_error_backtrace||sqlerrm);
end;

however, I get the following error:

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1369
ORA-29269: HTTP server error 500 - Internal Server Error
The line that generates the error is:

t_response := utl_http.get_response(t_request);

To prove that the service is active, run the following statement:

select utl_http.request('http://192.168.XXX.XX/.../RegistrarEvento')
from dual

and the query returns:

<?xml version="1.0" encoding="utf-8"?><wsdl:definitions name="RegistrarEvento" targetNamespace="http://tempuri.org/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:soap="http://schemas.xm...

That is, the service is active and other applications can consume this service without problem.

Other applications can consume this web service without problems. In the database server consumption tests are run using the application SoapUI and the result is satisfactory. The specific problem is trying to consume the web service from Oracle PL / SQL.

Error Codes
ORA-29273, ORA-06512, ORA-29269

Platform Information
This error is being presented on the following platforms:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production (Red Hat Linux)
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production (Red Hat Linux)
Confused
Re: ORA-29273, ORA-06512, ORA-29269: HTTP server error 500 - Internal Server in a Web Service PL/SQL [message #641777 is a reply to message #641776] Sat, 22 August 2015 16:18 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I'm trying to consume a web service

When all else fails try Reading The Fine Manual

http://docs.oracle.com/database/121/JJDEV/chtwelve.htm
Previous Topic: XMLTABLE
Next Topic: JDeveloper
Goto Forum:
  


Current Time: Thu Mar 28 05:37:21 CDT 2024