Hi
I have this piece of code which was working fine till yesterday but now it doesnt work,
UTL_HTTP.SET_HEADER (HTTP_REQ, 'Content-Length', LENGTH (SOAP_REQUEST));
UTL_HTTP.SET_HEADER (HTTP_REQ,'SOAPAction','"http://webapi/Streets_Events_Get"');
UTL_HTTP.WRITE_TEXT (HTTP_REQ, SOAP_REQUEST);
UTL_HTTP.WRITE_TEXT (HTTP_REQ, SOAP_REQUEST);
INSERT INTO XXHCC_STAGING_XML VALUES ((XMLTYPE (SOAP_REQUEST)), SYSDATE,'Street_Events_Get SOAP Request');
COMMIT;
--dbms_output.put_line('req is ' || http_req);
HTTP_RESP := UTL_HTTP.GET_RESPONSE (HTTP_REQ);
UTL_HTTP.READ_TEXT (HTTP_RESP, SOAP_RESPOND);
INSERT INTO XXHCC_STAGING_XML VALUES ((XMLTYPE (SOAP_RESPOND)), SYSDATE,'ssssss');
COMMIT;
UTL_HTTP.END_REQUEST(http_req);
UTL_HTTP.END_RESPONSE (HTTP_RESP);
I m posting a SOAP request and getting back a response, but now whats happening is I can see my Request xml in the staging table, but i dont get anything back in the response, May be the response is empty and when it inserts into staging table the empty response xml, it fails.
If i execute in PL/SQL i get the following error
ERROR at line 1:
ORA-30625: method dispatch on NULL SELF argument is disallowed
ORA-06512: at line 9
But in my error log i get is
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1222
ORA-29270: too many open HTTP requests
I m doing an END Request in the code above, but I dont know how to overcome this error
The webservice is working fine when tested independently.
My Environment is
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
Can someone let me know,
Many thanks
Sri