Calling a Oracle Stored Procedure in WEBI

[Former Member]

HI Guys!!

Can anyone help me, how to call a Stored Procedure in WEB Inteligence?

Also, can we call the Stored procedure in the Universe and that can be called in the WEBI?

If the WEBI doesn't support or has challenges then, I am also open for ideas using a stored procedure in crystal reports.

But finally I want the report to publish in BO Infoview.

Earliest response would be appreciated.

Thanks

Ajit

[Former Member]

somebody answered this question at http://technicalsupport.businessobjects.com/cs/forums/thread/5659.aspx but that site is not allowing to register. I searched here in this new forums site, but could not find it. Any help?

-Ravi

[giriraj_harapanahalli]

This is possible in XIR3 version. You can make a derived table in universe, which will call the stored procedure. Now you can use this universe in Webi and even pass parameters to stored procedure. I did try in MS SQL but should work for ORACLE as well.