mayora Posted January 23, 2014 Share Posted January 23, 2014 Hi Experts,How to pass jasper parameter of class java.util.collections in oracle stored procedure.I created stored procedure with table type param and passing the jasper parameter(java.util.collections parameter) in query language pl/sql.but I'm getting the below error: com.jaspersoft.ireport.designer.errorhandler.ProblemItem@a75c03Parameter type not supported in query : p1 class java.util.Collectionnet.sf.jasperreports.engine.design.JRDesignQuery@db8d63please help me out to solve this issue.Mayo Link to comment Share on other sites More sharing options...
marianol Posted January 23, 2014 Share Posted January 23, 2014 Well that will depend on what your storage procedure is expecting as a parameter, is it looking for list of comma separated values?, is it waiting strings to be quoted in a particular way?, does it expect only one value, etc, etc.In Jasper when you send a report a multi-select parameter that parameter as you said comes in the form of a java.util.Collection with a collection of the elements passed to the parameter. You can operate with that collection to extract the values the user selected and formated the way your SProc is expecting them.One of the simple things you can do is use the toString() method of the collection parameter like $P{MyMultiSelectParam}.toString() Link to comment Share on other sites More sharing options...
mayora Posted January 26, 2014 Author Share Posted January 26, 2014 Thank you Marianol, now it is working after converting it into tostring Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now