APEX

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!

download SSRS excel report using PL/SQL server side programming

696516Jul 20 2010 — edited Jul 20 2010

I have Oracle APEX application integrated with SSRS. I am using oracle PL/SQL UTL_HTTP package to request html report from SQL Server Reporting Services and then displaying this report to client browser on internet.

I have a new requirement to download the excel report from SSRS to oracle server then pass it to client machine. The requirement is for one report only, so we are not currently exposing SSRS to internet because our users are authenticated through our apex application. I am not sure if I can use UTL_HTTP.READ_RAW Procedure to get binary data from SQL Server Reporting services and then pass it to client browser. I can get data in raw form but how it would be passed to the browser on the client side.

If anyone can help it will be really appreciated.

Edited by: user2031507 on Jul 20, 2010 3:44 AM