Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
error when saving my oracle querry in 3.7.2 with parameters
Migrateduser
Hello,
I am using birt 3.7.2 with an oracle DB. I am creating a very simple report where the query is "select FIELD1 from TABLE1 where FIELD2 = ?"
When i click on OK to save my query i get an error saying:
"
A BIRT exception occurred.
Plug-in Provider:Eclipse BIRT Project
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:3.7.2.v20120213
Error Code:odaconsumer.CannotGetResultSetMetaData
Error Message:Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:Missing IN or OUT parameter at index:: 1
;
java.sql.SQLException: Missing IN or OUT parameter at index:: 1"
Note that when i replace the '?' by a hardcoded value evthg works fine and i am able to save my query.
Could you please help me?
Regards,
Boulos
Find more posts tagged with
Comments
There are no comments yet