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...
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.