ORA-01023 Invalid cursor number calling procedure from COM

Posted on 2005-04-05
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
    LVL 5

    Accepted Solution


    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 47

    Assisted Solution

    Use the Oracle OLEDb Provider instead the Microsoft one.
    This is an issue in the Microsoft OLEDB.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    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 how to recover a database from a user managed backup
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now