Ok Oracle gurus, yet another question. Is it possible to return cursors from an Oracle sp via ODBC? I found something on the Microsoft sight about passing back tables to create a cursor but if I read this correctly this is possible via the Microsoft driver for Oracle. I am using the Oracle driver because I could not get MS to work. This was such a simple task in SQL Server and it seems to be almost impossible in Oracle unless I am missing something.
I am also looking into using OO4O but that will be somewhere down the road due to the learning curve and my deadline on this current application. Plus, I think I read in the OO4O documentation that a cursor cannot be sent back from a stored procedure do to something about the ROWID's.
Does anyone do this or do you use straight SQL Passthrough? Stored procedures sure are nice because minor modifications can be made if needed without redistributing another .exe.
Anyway, thanks for your help.
George
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe