ADO Command and Oracle Ref Cursor

[andyskinner]

Hya,

I have an ADO command which calls an Oracle stored procedure that exposes a Ref Cursor. This calls ok, and I can get column names from the resultset of the procedure, however, it always says the recordcount is Zero and the recordset is empty, even though when executed in Oracle the procedure returns 5 rows.

Anyone got any ideas as to why this is happening? I can get data by executing a normal SQL statement, just not with this command and SP combination.

Andy.

 

[andyskinner]

I thought I might add that the parameter types I`m working with are dates, and I`m thinking this could be a problem. Not sure what to do about it though.

Andy