We have just done some work on this. You can use the SRW package that can be installed (scripts are in the as10gr2 directory structure. The reports manual has thorough documentation on it (we used the report distribution stuff to automatically e-mail the resulting PDF to a recipent that is looked up). The code we came up looks something like this (this is still in dev phase):
FUNCTION run_distribution_report(a_ord_id IN wpe_orders.ord_id%TYPE,
a_distribution_xml IN VARCHAR2,
a_send_to_requestor IN VARCHAR2,
a_report_name IN VARCHAR2 DEFAULT 'wo.rdf') RETURN VARCHAR2 IS
You can call that from PL/SQL using HOST/SHELL command. Have you tried this workaround ??
And Raj, The SRW package you can install on your database and kick your reports from there. That's what the above thread talks, i think. You can try the scripts available in C:\DevSuite10gR2\repadm61\UTL folder. :) It is also a built-in for Reports.
I found a work around for the SRW solution using the UTL_HTTP package.
The SRW package looks like a solution made just for 10g and higher... I tried installing it into my database and it told me that the version was wrong... im using a 10g AS but 9i DB... should I be running the 9i AS version of SRW?
Now im trying to figure out if its possible to run a report and store the results directly into the database in a blob... anyone done this before?