Exception "NET: Unknown error 1" during execution OraCommand in Direct mode.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
yevgeny
Posts: 15
Joined: Sun 11 Sep 2005 16:51
Location: Israel
Contact:

Post by yevgeny » Sun 24 Feb 2008 13:47

The test project is very simple - here is the C# side:

Code: Select all

namespace MultiCursor
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            oracleConnection1.Open();
            try
            {
                oracleCommand1.ExecuteNonQuery();
            }
            finally
            {
                oracleConnection1.Close();
            }
        }
    }
}
And here is the DB side:

Code: Select all

TYPE ref_cursor IS REF CURSOR;

PROCEDURE SP_MULTI_CURSORS(
          cursor1 out ref_cursor,
          cursor2 out ref_cursor)
IS
BEGIN
  open cursor1 for
  select dummy from dual;

  --open cursor2 for
  --select dummy from dual;
END;
When opening the second cursor is not commented out, everything works fine.
I've sent it also to [email protected]

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Mon 25 Feb 2008 17:11

We have got your project and we reproduced the error.
Thank you for the bug report.
We will fix it in the nearest time.

Pcx
Posts: 2
Joined: Thu 31 May 2012 13:35

Re: Exception "NET: Unknown error 1" during execution OraCom

Post by Pcx » Thu 31 May 2012 13:46

Would it be possible to know in which exact version this bug is supposed to be fixed.
Tks

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Exception "NET: Unknown error 1" during execution OraCom

Post by Pinturiccio » Fri 01 Jun 2012 10:25

The bug with the null cursor parameter in the Direct mode was fixed in dotConnect for Oracle 4.50.31 on 19-Mar-2008. For more information, please refer to http://www.devart.com/dotconnect/oracle ... story.html

Pcx
Posts: 2
Joined: Thu 31 May 2012 13:35

Re: Exception "NET: Unknown error 1" during execution OraCom

Post by Pcx » Fri 01 Jun 2012 15:50

Tks for your prompt answer :wink:

Post Reply