Returning data from oracle procedure

[MikeKeane]

Hi,
Does anybody know how to return query rresults from an oracle procedure using business objects?

Thanks

 

[sadhi]

Open BusinessObjects.

Create a new report with new report wizard.
create a new report

in specify data access page select 'others'
select 'Stored Procedure'

Select a connection : fi you do not see any available connection then go to desiner universe and create one.

Select the required Stored procedure

You are all set.

 

[nimmy99]

Yes. If you have any input parameters, select the name of the parameter and type the value for that in value box