title: Jaspersoft Studio: How to send a array parameter (table of numbers) to an pl/sql function?
body: <p>I want to send a list of numbers to a pl/sql function. The typedef of the argument is: <code>TYPE colNumbers IS TABLE OF NUMBER(5,0)</code>. In a normal SQL query i call my function with </p>
  
  <pre><code>select (Test.argLoN(colNumbers(1,2,3,4,5,6))) as "asd" from dual 
  </code></pre>
  
  <p>This part works fine.</p>
  
  <p>I read that JR engine call the toString() method of the parameters. So in ireport 5.5.1 (the eclipse plugin version) I created a parameter with type String and give him the "default expression" "1, 2, 3, 4, 5, 6, 7, 8, 9, 10". In the query dialog I call the statement: </p>
  
  <pre><code>select (Test.argLoN(colNumbers($P{val})) as "asd" 
  from dual
  </code></pre>
  
  <p>If I run the report I get this error msg: </p>
  
  <blockquote>
    <p>net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Test</p>
  </blockquote>
  
  <p>If i understand this right. </p>
  
  <pre><code>select (Test.argLoN(colNumbers($P{val})) as "asd" from dual" 
  </code></pre>
  
  <p>with val = "1,2,3,4,5" should create </p>
  
  <pre><code>select (Test.argLoN(colNumbers(1,2,3,4,5))) as "asd" from dual
  </code></pre>
  
  <p>Or did I misunderstand it?</p>