can we call Oracle package which contains Stored Procs in Universe

[Former Member]

HI,

I have a Stored procedure universe created in BI 4.0 using Universe designer tool

now my requirement is to call / use few stored procedure which is inside a Package   ( Oracle 11 g - Package which has custom report specific Store procedure)

When I am trying to add the package, it is not showing up in the Add stored Procedure list..

Can we really use/call a stored procedure with in a package in BI 4.0 Universe designer

Environment Details : BI 4.0 SP2 , Oracle 11g 

Thanks

Vijay

[former_member182521]

Hi Vijay,

Can we create a separate procedure which in turn calls the SP's of your interest as a work around instead of looking for Package access which is not supported?

Regards,

Mani