ref_cursor in a procedure does not work for Microsoft ODBC for oracle driver
Posted on 2006-07-11
I have a stored procedure to retreive record set values from db.
so i used PL/SQL table type. that is
type tt1 is table of ........
but if i replace the table type with ref_cursor i get an ODBC error :
"ODBC driver does not support the requested properties.--2147217887".
The problem is i get a connection string from other module and i cannot change the connection string. that is i cannot change the driver.
So is there a way to get it working the ref_cursor using "Microsoft ODBC for Oracle" driver.