ORA-01023 Invalid cursor number calling procedure from COM

Posted on 2005-04-05
Medium Priority
Last Modified: 2012-06-27
Migrating from 8.16 to 9.2. I have a VB COM object calling a procedure that returns a dynamic cursor. It works fine in 8.16 but throws ORA-01023 error when we try it in 9.2. Any help would be appreciated.
Question by:krisizon

Accepted Solution

helpneed earned 500 total points
ID: 13713972

The cursor number is not a valid open cursor.

Make sure that the cursor is open.

this is because Microsoft provider requires open cursor

try to call a stub procedure that open cursor if not opened.


LVL 48

Assisted Solution

schwertner earned 500 total points
ID: 13714619
Use the Oracle OLEDb Provider instead the Microsoft one.
This is an issue in the Microsoft OLEDB.

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
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…
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
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

830 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