Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

too many http requests and null self argument is disallowed

344384May 30 2012 — edited Jun 6 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2012
Added on May 30 2012
9 comments
2,486 views