Accessing Oracle stored procedures vs. functions

building reports desktopintelligence
1

Hello!
I was wondering if anyone out there knows if Business Objects can call an Oracle function that returns a record set rather than an Oracle stored procedure. Currently, I am running a stored procedure and then running free hand SQL in BO to get the report. I would like to do this in one step, but I get an error when trying to use code that doesn’t start with “select”.
Any help is appreciated.
I look forward to meeting many of you at the user conference! :slight_smile:
-Sarah

Sarah McCurley (BOB member since 2002-08-29)

2

Sarah,

As far as I know you can only use stored Procedures if the retrieve data.

Functions are much more flexible and can be used inside a universe much like a Sum, Count or Decode.

We use many functions mainly for the following calculations:

Business Hours/Day since Date in the database
Conversion of Units
Complexe decode statements
…

Hope this helps.

Klaus

ClaireB :de: (BOB member since 2002-08-09)

3

Speaking from frustration…I mean experience…

A stored procedure must have a ref cursor and a select. At least as far as I’ve been able to learn…I’d love somebody to prove me wrong!

Here’s what I’ve put in the FAQ

Eileen King :us: (BOB member since 2002-07-10)