Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 585
  • Last Modified:

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
0
garavindbabu
Asked:
garavindbabu
2 Solutions
 
schwertnerCommented:
Use Oracle ODBC instead.
Download it fron Oracle Technology Network.
0
 
sathyagiriCommented:
MICROSOFT ODBC does not support ref cursor. You could use Microsoft OLEDB for Oracle or use the Oracle ODBC as suggested earlier.

See this article
http://support.microsoft.com/kb/255043/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now