Is it possible to use a Derived table against an Oracle stored Proc. I looked through the discussion threads and I saw examples with SQL Server stored procs. The problem with the Oracle ones is a little different and I was wondering if anyone has done it. When I try to do something like this
select * from mystoreproc(‘test’,mycursor), I get an error saying that it is missing the right paranthesis.
Any thoughts?
TIA
geoenvy 
(BOB member since 2005-10-20)
As per my understanding
You can not enter through designer.It is possible only at report level
Insert sp as new data provider
Raj
sanjana (BOB member since 2007-01-19)
Hi
As said by sanjana, you can use the SP as the Dataprovider for Designing the report, even you can call the function @Universe, am not sure about the stored procedure…
Regards
Siva.M
looksmee 
(BOB member since 2006-02-08)
Do you mean use it in a Web Intelligence report directly? Can you let me know how?
geoenvy (BOB member since 2005-10-20)
ohhh You are talking about sp through webi.
Sorry I thought you are in deski ,through infoview
sanjana (BOB member since 2007-01-19)
Even Deski through Infoview does not allow SP as data source 
. It only lists 3 Data sources and SPs are not one of them…
geoenvy (BOB member since 2005-10-20)
Sorry , my statement leads to confusion,
I mean to say, You can create a report based on stored procedure through desktop intelligence.
Through Infoview you can refresh deski reports, what ever is the dataprovider.
sanjana (BOB member since 2007-01-19)