Home » Developer & Programmer » Reports & Discoverer » Call procedure in oracle reports (Oracle Reports, 10G,Win 7 )
Call procedure in oracle reports [message #641864] Wed, 26 August 2015 01:17 Go to next message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Hi all

Appreciate if someone help me out, I have a query that is common for all my reports, Is there any option in Oracle reports through which I can create procedure for that common query and call that procedure in oracle reports builder..
Re: Call procedure in oracle reports [message #641865 is a reply to message #641864] Wed, 26 August 2015 02:13 Go to previous messageGo to next message
Littlefoot
Messages: 21509
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't think so.

However, you could create a table whose description matches columns returned by your "common query). Then, create a (stored) procedure which will utilize the "common query" and perform INSERT INTO the newly created table.

In a report, call that procedure from the After Parameter Form trigger. It will insert values into the table.

Finally, modify report's query so that it doesn't use "common query" any more, but selects values procedure inserted into the table.

You'd, of course, do the same in all reports.
Re: Call procedure in oracle reports [message #641867 is a reply to message #641865] Wed, 26 August 2015 04:19 Go to previous messageGo to next message
cookiemonster
Messages: 13715
Registered: September 2008
Location: Rainy Manchester
Senior Member
Is there any reason you can't use a view for this?
Re: Call procedure in oracle reports [message #641868 is a reply to message #641867] Wed, 26 August 2015 04:57 Go to previous messageGo to next message
Littlefoot
Messages: 21509
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
/forum/fa/2115/0/ That would be a MUCH better idea than mine!
Re: Call procedure in oracle reports [message #642012 is a reply to message #641868] Sat, 29 August 2015 20:40 Go to previous messageGo to next message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Thanks for the replies, I think I can use view as mentioned above by cookiemonster but I really like the idea of Littlefoot. Thanks again
Re: Call procedure in oracle reports [message #642047 is a reply to message #642012] Tue, 01 September 2015 03:10 Go to previous messageGo to next message
cookiemonster
Messages: 13715
Registered: September 2008
Location: Rainy Manchester
Senior Member
LF's approach sounds unnecessarily complicated - if you do try it make sure you use a global temporary table.
Re: Call procedure in oracle reports [message #642280 is a reply to message #642047] Sat, 05 September 2015 21:40 Go to previous message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Sure. I will try..Thanks
Previous Topic: Report Execution using command line
Next Topic: Problem while running two reports consecutively
Goto Forum:
  


Current Time: Wed Nov 13 05:58:42 CST 2019