Procedures, returning data.

[MikeKeane]

Hi,
Im trying to get BO to return data via a stored Procedure (Oracle). However i always get 'No Data Returned', even with something as simple as 'select sysdate in myVar from dual'. How do i return this value into the BO Report?
Thanks

 

[ReportingDeveloper]

I think you have not read the documentation completely. The select query u have used doesn't seem to be correct. The only way you can return data to BO is through cursors, so you have to have a cursor return type and then open the cursor in u r stored proc. The cursor type declared in the out parameter list must be defined in the same package.

 

[MikeKeane]

Cheers, u were right, i didnt read the documentation at all!
Just assumed thats all that was needed!.
Thanks