Hi,

The recordset returned by the cursor is assigned to an array declared in VB to be used later for processing.
When we assign it to the array in VB it gives the following error:

Run-time error '-2147467259 (80004005))':
CLI0112E Error in assignment. SQLSTATE = 22005

The scenario in detail:
We have three cursors which return three recordsets.The first two recordsets contain data from the tables.
The third recordset is obtained by making a join with two different tables.When we run this procedure in the Stored procedure builder,
we get the results in the output window.They are correct.But when we assign this recordset to an array in VB it gives the above mentioned

error.

cursor1:gets data from a table
cursor2:gets data from a table
cursor3:gets data from two tables based on a join.

There other Scenario was:
When we interchanged the cursors

cursor1:gets data from two tables based on a join.
cursor2:gets data from a table
cursor3:gets data from a table

The recordset returned by the cursor1 was truncated.
Why would the results get truncated.

There was another unbelievable result.
We are passing some parameters to the procedure.Suppose we do not pass those parameters.The procedure works.But the procedure is of no use if we do not pass the parameters.So how do we go about this.

With Regards,
Deepak