Re: can i run a stored procedure from Reports?

From: <>
Date: Mon, 09 Aug 1999 14:54:00 GMT
Message-ID: <7omq22$gr6$>

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


In article <>,   bmlam <> wrote:
> Since the figures I have to calculate require pretty complex
> calculation, I wrote a stored procedure in PL/SQL to compute the
> 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
> 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
Share what you know. Learn what you don't. Received on Mon Aug 09 1999 - 16:54:00 CEST

Original text of this message