Run procedure before retrieve the data [message #426974] |
Tue, 20 October 2009 07:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hsbdba
Messages: 5 Registered: October 2009
|
Junior Member |
|
|
Hi everyone,
I have Oracle Discoverer 4.1.37.00.0 desktop edition.
the case that I want to run a report reading from Temporary table and view the data in Discoverer workbook.
My inquiry is how to run a procedure before run the report from Oracle Discoverer so this procedure fill the temporary table as the following process:
Run Report ----> Run procedure ----> Fill temporary table ----> view report
is that possible? How? and what is the Workaround?
|
|
|
Re: Run procedure before retrieve the data [message #427051 is a reply to message #426974] |
Tue, 20 October 2009 15:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Huh, I don't use Discoverer but - if there's any similarity with Reports - you'd do that in before report trigger. If not, let's hope that someone who knows the answer sees your question.
|
|
|