Cannot create dataset parameter Oracle 11

svyates

I'm using 4.2.1 and am having an issue with an Oracle 11 database. When I try to create a parameter in the dataset, it doesn't get created. The query runs fine until I try to add the parameter. where field = ? Nothing gets created in the parameter tab and the query generates the error "SQL statement does not return a ResultSet object"
I saw references to similar problems and one of the suggested solutions was to add the where clause to the before open script. Can you give me an example of how to do that? Or, is there a solution to what seems to be an Oracle 11 issue. I have no problems with MySQL.
Thanks!

Steve

CBR

Hi steve,

could you try to add a parameter to the parameters tab by simply clicking on add?

The solution you read about is to go to the Property Binding tab in the dataset editor dialog. There is a field called query text. This field can be used to overwrite the query by using a Rhino Script expression.
e.g.:
You could provide a query like:

Select * from products
in the normal query editor

and then in the Property Binding tab:

"select * from products where id="+params["id"].value

Please be aware that this solution might introduce serious security issues. Not sure if you ever read about SQL injection. SQL injection could happen if params["id"] is freetext entered by your endusers.
This SQL injection can not happen if you use the normal parameters feature.