OraFAQ Forum: Reports & Discoverer » Calling a procedure from Oracle Discoverer

Home » Developer & Programmer » Reports & Discoverer » Calling a procedure from Oracle Discoverer (Oracle Discoverer BI)

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

Calling a procedure from Oracle Discoverer [message #336738]

Mon, 28 July 2008 16:05

Leonard Martin
Messages: 45
Registered: May 2002
Location: Canada

Member

Hello all

Is is possible to call a procedure from Oracle Discoverer ?
If so, could you please let me know or if there are any other alternatives ?

Thanks
Leonard

Report message to a moderator

Re: Calling a procedure from Oracle Discoverer [message #337140 is a reply to message #336738]

Wed, 30 July 2008 01:08

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

No, Discoverer is for selecting data only, so no PL/SQL. However, if you can find a way to "hide" (call) your procedure in a function, you could call that function in Discoverer.

Report message to a moderator

Re: Calling a procedure from Oracle Discoverer [message #337318 is a reply to message #337140]

Wed, 30 July 2008 09:47

Leonard Martin
Messages: 45
Registered: May 2002
Location: Canada

Member

Thanks
Can you tell me how to call a function from discoverer ?

Leonard

Report message to a moderator

Re: Calling a procedure from Oracle Discoverer [message #337322 is a reply to message #337318]

Wed, 30 July 2008 10:04

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Register the function in the EUL and enable it for use by end-users.
See the documentation: http://download.oracle.com/docs/html/B13916_04/calculations.htm#sthref798, "About registering custom PL/SQL functions"

Report message to a moderator

Re: Calling a procedure from Oracle Discoverer [message #337326 is a reply to message #337322]

Wed, 30 July 2008 10:07

Leonard Martin
Messages: 45
Registered: May 2002
Location: Canada

Member

Thank you !

Report message to a moderator

Re: Calling a procedure from Oracle Discoverer [message #337327 is a reply to message #337326]

Wed, 30 July 2008 10:08

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

You're welcome!

Report message to a moderator

Re: Calling a procedure from Oracle Discoverer [message #337329 is a reply to message #337327]

Wed, 30 July 2008 10:12

Leonard Martin
Messages: 45
Registered: May 2002
Location: Canada

Member

Just a quick question, in case i have a sql script (find attached) that produces a report and i want to use discoverer instead, how would i build a report just like the one the sql script produces ?

Thanks

Attachment: 9590.sql
(Size: 5.42KB, Downloaded 1329 times)

Report message to a moderator

Re: Calling a procedure from Oracle Discoverer [message #337471 is a reply to message #337329]

Thu, 31 July 2008 00:54

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Do you have a sample of the required output?

Basically, Discoverer can only do select. So, if you have some PL/SQL code (like your script), you somehow have to turn that into plain SQL for Discoverer to be able to use it.

Your code looks as if with some clever case when statements it should be possible to rewrite it using only SQL, right?

Report message to a moderator

Previous Topic:	independent query..
Next Topic:	Multiple Parameter Handling

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 23:31:26 CST 2024