Hi,
I am bad in english but i will try to explain my problem.
i am trying to connect procedure to CR.
my procedure should be designed in such a way that unlimited times by unlimited number of users can run the report and see the data on-demand.
They may refresh multiple times or run different reports multiple times and keep them open in their systems.
now my problem is
In procedure i am using reference cursor to throw output to report like
open cursor_name for
select x,y,z from a
if the same report is used by multiple users multiple times the data loded in final table 'a' is huge.
my point is can i delete the data after the output is thrown to report means can i use delete statement after the
open cursor_name for
select x,y,z from a
in procedure.
Thanks & Regards,
Sruthi
IP Logged
