Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to pass the parameter of a stored procedure to iReport

843841Oct 20 2005 — edited May 27 2008
Hi... i don't know how to pass the parameter of the stored procedure to the iReport.

In the Report Query, i tried

1. sp_storedprocedure ' value'
2. sp_storedprocedure +''''+$P{parameter}+''''+
3. sp_storedprocedure +$V
+$P{parameter}++$F
($F
is a variable having a value of ' (a single quote))
may you enlighten us please? thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2008
Added on Oct 20 2005
4 comments
776 views