Ref cursor i OracleDataset - doesn't work in design time

[Helene]

I have only recently tried this method, and generally I am quite happy with the way it works. It seems to be an easy way to refactor the data access layer, moving the actual SQL statement to a package in the database. Nothing needs to change in Delphi except the SQL statement of the Oracle Dataset, and its variables.

However, I would like to be able to execute/parse this statement in design time, to make sure it works before I actually compile and run the application. This doesn't work.

In the SQL Editor window I get an error message "Cursor variable :curs cannot be nil", both from the parse and the execute button.

Then when I try testing it through setting the Active property to True in the Object Inspector, this causes all the variables for the dataset to be removed!

With regards, Helene

 

[Marco Kalter]

This is indeed a restriction at the moment. The SQL Editor does not have the TOracleDataSet flexibility at the moment to dynamically assign a TOracleQuery instance to the cursor variable. We'll add this, so that you can quickly parse things and preview the result set.