Problem with OUT RefCursor in a Stored Procedure

haggu-hans · Post by **haggu-hans** » Wed 23 Dec 2009 10:34

Hi together

I got a generally Problem with OUT Ref Cursors in Stored Procedure. I try to use a Stored Procedure to create a SQL-Report in VS2008 but i get no data.

When i try to define a new dataset in the report with a stored procedure like:

fast.pkg_role.getlist

and define the parameter in the parameterlist, so i get no error-message and no data. With tables and views seems to be ok, i receive the field-definitions and the data's. So what's wrong with stored procedures ?

Best regards,
haggu-hans

StanislavK · Post by **StanislavK** » Wed 23 Dec 2009 15:17

Thank you for the report. We will investigate the situation and inform you about the results as soon as possible.

StanislavK · Post by **StanislavK** » Thu 24 Dec 2009 14:41

Stored procedures are not executed at design-time. Hence, design-time tools have no information on fields in the cursor and thus DataSets created from cursors cannot be binded at design-time.

On the other hand, the cursor DataSets are filled successfully and you can use them at run-time.

Also, we plan to add the cursor support in Report Wizard of VS Reports Applications, but cannot provide any timeframe.