Jump to content

java.util.collection parameter in pl/sql


Recommended Posts

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@db8d63

please  help me out to solve this issue.


Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...