Re: can i run a stored procedure from Reports?

I suppose it should be: "calcuation_procedure;" and not "execute calcuation_procedure;"

Mvg,
DirKos

bmlam heeft geschreven in bericht <37AB4A63.A4C89830_at_online.de>...
>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
>
Received on Sun Aug 15 1999 - 22:26:02 CEST