Call procedure with report designer 3.6

[miscvinod]

I believe the procedure call is not clear in the image so here is the more clear version in text format.

{call proc_geoDetails1(${OperatingSystem})}

[Frank Chen]

Hi miscvinod,How to get result from the oracle procedure?
The example is not the oracle procedure, isn't it? In oracle, we cant only use the select.Could you give an oracle example?
Thanks!
Frank

[miscvinod]

Sorry Man... It seems like I am 7 months late here... Actually was quite away with the tech stuff.

Anyways here is the answer.
Just call the procedure with following syntex.
Syntex
----------
{call <procedure name>(${<parameters that will be evaluated against select where clause>})}

Example
----------
{call proc_geoDetails1(${OperatingSystem})}

Note :- Ignore < and > signs they are there just for the distinction.

[sadakar]

Hi folks,

It's well worked nice job.

Now if we want to display multiple result sets in Pentaho report designer, how it is possible ?

Suppose my stored procedure gives 3 different result sets .
1st result set is having 2 rows,2 columns
2nd result set is having 10 rows,5 columns
3rd result set is having 3 rows, 8 columns

First I need to display these 3 result sets of data as output and I wanna use 2nd result set for reporting.

How it is possible in PRD ?

Thanks in Advance.
SADAKAR P