garavindbabu
asked on
ref_cursor in a procedure does not work for Microsoft ODBC for oracle driver
Hi,
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.
Thanks
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.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.