<p>Hi everyone,</p>
<p> </p>
<p>I have a field name, which was created from:</p>
<p> </p>
<p>select fname || ' ' || mname || ' ' || lname as name</p>
<p>from table</p>
<p> </p>
<p>Now, if I run this query as pl-sql editor:</p>
<p> </p>
<p>select * from table</p>
<p>where name = 'fname mname lname' - it works,</p>
<p> </p>
<p>If I pass the NParameter in the Birt report design as:</p>
<p> </p>
<p>select * from table where name = ? in the dataset, I got this error:</p>
<p> </p>
<div>Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: DataSetName</div>
<div>Cannot set the string value () to parameter 7.</div>
<div> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot set preparedStatement parameter string value.</div>
<div>SQL error #1:Invalid column index</div>
<div> </div>
<div>This is how I set/define my parameter.</div>
<div>I got the same error whether I ran it in the Dataset Preview or in View Report. Can you please help me find where I went wrong ?</div>
<div>Thanks</div>
<div> </div>
<p> </p>
