Solved

ref_cursor in a procedure does not work for Microsoft ODBC for oracle driver

Posted on 2006-07-11
4
575 Views
Last Modified: 2008-01-16
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
Comment
Question by:garavindbabu
4 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 25 total points
ID: 17081987
Use Oracle ODBC instead.
Download it fron Oracle Technology Network.
0
 
LVL 14

Assisted Solution

by:sathyagiri
sathyagiri earned 25 total points
ID: 17082764
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
grant user/role question 11 32
best datatype for oracle table email creation 8 55
Row_number in SQL 6 33
Help with Oracle IF statment 5 23
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question