And the problem is?
Some exceptions are errors - like attempting to divide by zero. Some exceptions are simply indicators that the current operation cannot be executed any more.
E.g. when telling the cursor to give you more data (doing a fetch), the cursor says "no more data". Is this an error? No - it is simply an exception that says that there are no more data to fetch.
Same thing for this HTTP exception. You attempt to fetch more chunks from the HTTP response to a HTTP command and there are no more chunks to fetch.. you have 'em all.
Thanks for your reply :)
But the problem here is UTL_HTTP.request_pieces() function is itself throwing this exception,
The piece of code that actually read this information (returned from the UTL_HTTP.request_pieces()), is still not processed.
Do you have any idea, why it is behaving like this??
Please post your entire script.
I am invoking following piece of PL/SQL block from java.
? := UTL_HTTP.request_pieces('http://abc.com:7179/reports/rwservlet?PRD&server=prd&destype=cache&desformat=xml&report=myreport.rdf&P_PARAMETER_CODE=13');
This block returns me table type data set, which i am capturing using registerIndexTableOutParameter(1,100,OracleTypes.CHAR,0), method of native OracleCallableStatement class.
Actually this piece of code is working fine with small reports but with large reports it is throwing error..
I still do not see the problem...
Simply catch and suppress that exception if you do not want the caller to be aware of it. Or, as the caller, when you see that exception, treat it as reaching the end-of-file of the HTTP stream.
Hi, I got the same problem when trying to fetch big size report from Oracle Report Server, I just used the Oracle provided API "SRW.RUN_REPORT" in PL/SQL procedure, it works well with small size reports, but failed when the report is little bit big, in my case , it's about 180KB in PDF format.
ORA-20212: ORA-06512: at "SRW", line 622 ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP",line 1674 ORA-29259: end-of-input reached
I used the same code generating reports for different customers, 9 customers are OK, only one failed which got the most data. And actually, I checked the report server, the report was generated successfully several minutes later, just after return that exception.....
I set the transfer timeout "UTL_HTTP.set_transfer_timeout(1000)", so that's nothing to do with timeout...
Do you have any idea about this? Thanks in advance..
Please do not resurrect old and dead threads (this one is over 6 years old), and hijack the thread, to ask your question.
Post a new thread. That way you OWN the thread and conversation and problem. That way you reach the ENTIRE regular audience of this forum.
If it add relevance, include a URL to an old posting when you create your new posting.