We have a complex application that has been developed using SQL Server.

We are now in the process of converting this to run with an Oracle 8i database as well and are experiencing problems using the Data Environment against stored procedures. The ideal solution would be for Oracle to return command fields in the same manner as from a SQL Server stored procedure, rather than into an explicit Ref Cursor (thus meaning we do not have to alter our complex application).

Does anyone have experience of doing this (we are using Oracle OLEDB or Oracle ODBC 8.1.5.7.0)

Thanks

Simon