How to Call PLSQl procedure in jasper

[jamunatgowda28]

Dear All

AM using  " TIBCO Jaspersoft Studio-6.3.0 " in this  am not getting how to call procedure  actually i tried like i report but am not getting ,please if any one knows  means please get it back 

Thanks

[mlopez_1]

A procedure using scriptlets and functions inside SQL query.

 

Cheers

[ajay_1311]

call procedure name only with parameter-:

In dataset and queries

<prcedure_name><parameter1>,<parametter2>

 

e.g

1) dbo.SP_Report  $P{date_from}, $P{date_to} OR

2) dbo.SP_Report  @p1=$P{date_from}, @p2=$P{date_to}

3) call dbo.SP_Report  $P{date_from}, $P{date_to}  

 

Regards

Ajay

[jamunatgowda28]

thanks ajay ..but am not able to call IN OUT  parameter