OraFAQ Forum: JDeveloper, Java & XML » ORA-29273, ORA-06512, ORA-29269: HTTP server error 500

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

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