OraFAQ Forum: Reports & Discoverer » Call procedure in oracle reports

Home » Developer & Programmer » Reports & Discoverer » Call procedure in oracle reports (Oracle Reports, 10G,Win 7 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Call procedure in oracle reports [message #641864]

Wed, 26 August 2015 01:17

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..

Report message to a moderator

Re: Call procedure in oracle reports [message #641865 is a reply to message #641864]

Wed, 26 August 2015 02:13

Littlefoot
Messages: 21759
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.

Report message to a moderator

Re: Call procedure in oracle reports [message #641867 is a reply to message #641865]

Wed, 26 August 2015 04:19

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

Is there any reason you can't use a view for this?

Report message to a moderator

Re: Call procedure in oracle reports [message #641868 is a reply to message #641867]

Wed, 26 August 2015 04:57

Littlefoot
Messages: 21759
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That would be a MUCH better idea than mine!

Report message to a moderator

Re: Call procedure in oracle reports [message #642012 is a reply to message #641868]

Sat, 29 August 2015 20:40

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

Report message to a moderator

Re: Call procedure in oracle reports [message #642047 is a reply to message #642012]

Tue, 01 September 2015 03:10

cookiemonster
Messages: 13904
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.

Report message to a moderator

Re: Call procedure in oracle reports [message #642280 is a reply to message #642047]

Sat, 05 September 2015 21:40

shumail
Messages: 149
Registered: September 2012
Location: Canada

Senior Member

Sure. I will try..Thanks

Report message to a moderator

Previous Topic:	Report Execution using command line
Next Topic:	Problem while running two reports consecutively

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 05:20:57 CDT 2023