Derived Table - Stored Procedure.

[Former Member]

Hi all,

Can any tell how you call stored procedure from Derived table.

and how manage the IN parameters ?

thnx in advance

[Former Member]

Hi Reddeppa,

Could you please specify the database you are working on?

Also , BO Supports Derived Tables if and only if the underlying database supports In-line Views:

Syntax: Select tot from ( select fun(x) as tot from table) dtab ;

Ex: Select workdays from ( select workdays('10/10/2004' , '20/4/2005') as workdays from dual ) DerivedTab ;

Run the above SQL at the Database end, if it runs successfully then follow the below steps

1. Create a function at the database end.

for example :

Create or replace function testf(no number) return number

as

Begin

Return(10);

End;

2. Open the universe

3. Create a derived table using the following syntax:

for example :

Select TestF(10) from dual;

4. Click on parse and Ok.

5. Now create a report using Derived table

Note: This is tested on Oracle database.

Hope this will help you.

Regards

Sheeba

[Former Member]

Hi Sheebha,

thnx for ur prompt respond..

i am using oracle as database.

suppose i have requirement like below,

i am passing dept id as input parameter now i want detials of particular dept id details including dept name and their employee details .

how can acheive this through derive and stored peocedure

[Former Member]

Someone please answer this. I need this too