Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 582
  • 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

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

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