Re: can i run a stored procedure from Reports?

You don't need to specify the 'execute' prefix to the procedure if you call it from within a PL/SQL block.

-Rajini

In article <37AB4A63.A4C89830_at_online.de>,   bmlam <bmlam_at_online.de> wrote:
> Since the figures I have to calculate require pretty complex
> calculation, I wrote a stored procedure in PL/SQL to compute the
figures
> and store them in a table . Then I create a query with Reports to get
> the data in the report sheet . Now the point is we want to run the
> calculating procedure (1) immediately before the report is run (2).
>
> I know I can do it with a script to synchronize the 2 tasks. But a
> better way would be to imbed step 2 in the report itself, sort of in
one
> of the report trigger. The trouble is you can not issue "execute
> calcuation_procedure;" in the trigger.
>
> So is there a solution to this?
>
> Thanks
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 09 1999 - 16:54:00 CEST