Link to home
Start Free TrialLog in
Avatar of garavindbabu
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
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial