Solved

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

Posted on 2006-07-11
4
577 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to recover a database from a user managed backup

713 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