Home » Developer & Programmer » Reports & Discoverer » Calling a procedure from Oracle Discoverer (Oracle Discoverer BI)
Calling a procedure from Oracle Discoverer [message #336738] Mon, 28 July 2008 16:05 Go to next message
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
Re: Calling a procedure from Oracle Discoverer [message #337140 is a reply to message #336738] Wed, 30 July 2008 01:08 Go to previous messageGo to next message
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.
Re: Calling a procedure from Oracle Discoverer [message #337318 is a reply to message #337140] Wed, 30 July 2008 09:47 Go to previous messageGo to next message
Leonard Martin
Messages: 45
Registered: May 2002
Location: Canada
Member
Thanks
Can you tell me how to call a function from discoverer ?

Leonard
Re: Calling a procedure from Oracle Discoverer [message #337322 is a reply to message #337318] Wed, 30 July 2008 10:04 Go to previous messageGo to next message
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"
Re: Calling a procedure from Oracle Discoverer [message #337326 is a reply to message #337322] Wed, 30 July 2008 10:07 Go to previous messageGo to next message
Leonard Martin
Messages: 45
Registered: May 2002
Location: Canada
Member
Thank you !
Re: Calling a procedure from Oracle Discoverer [message #337327 is a reply to message #337326] Wed, 30 July 2008 10:08 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
You're welcome!
Re: Calling a procedure from Oracle Discoverer [message #337329 is a reply to message #337327] Wed, 30 July 2008 10:12 Go to previous messageGo to next message
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 1331 times)
Re: Calling a procedure from Oracle Discoverer [message #337471 is a reply to message #337329] Thu, 31 July 2008 00:54 Go to previous message
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?
Previous Topic: independent query..
Next Topic: Multiple Parameter Handling
Goto Forum:
  


Current Time: Tue Dec 03 18:36:27 CST 2024