Link to home
Start Free TrialLog in
Avatar of zmouser
zmouser

asked on

Is there a way to return data from a stored procedure in BusinessObjects XI R2

I have an existing stored procedure that was a part of a Crystal Report.  I would like to move this to a WebI report, which does not appear to support stored procedures out of the box.  I am using an Oracle database, which seems to have some limitations when it comes to views, namely, that you cannot perform DML operations from select statements.  That all means that, 1) in order to create my WebI report, I have to have a view (or table) to select from, and 2) I cannot use data manipulation operations to do this, because using a view would require those to be executed in a select statement.

My question is, what are my options?  It seems that, with the complexity of a data-warehouse, it's would be difficult to access and manipulate all data in cursors and views.  Is there something I am missing, and WebI can execute stored procedures?

Thanks a lot for the advice, I'm new to BusinessObjects, and could very well be missing something very obvious.

--Zach
ASKER CERTIFIED SOLUTION
Avatar of Walter Ritzel
Walter Ritzel
Flag of Brazil image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Here is the link:
http://psoug.org/reference/pipelined.html

I have tested the examples, they work perfectly.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike McCracken
Mike McCracken

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.