Reports enhancement

[ANafziger]

Is there any way to run a stored procedure or sql script from a report window? If not, it would be a nice feature.
You could simply require that the procedure return either a sys_refcursor or scalar and use the existing variable structure for parameters.

 

[Marco Kalter]

This is currently not possible. I have added this to the list of enhancement requests.

 

[ANafziger]

Thanks. I currently use the Reports interface to run some frequently used update statements but it would be nice to run a proc (or at least more than one statement) in there as well (i.e. error checking and return output). It would be cool if you could display either an implied sys_refcursor, scalar, and/or DBMS_Output.

 

[Claus Pedersen]

I too can vote for this request.

It would be really usefull to be able to run for example a PL/SQL procedure that could publish data in a temporary table before the report is run.