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

Postby 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 support@crlab.com
yevgeny
 
Posts: 15
Joined: Sun 11 Sep 2005 16:51
Location: Israel

Postby 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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

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

Postby 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
Pcx
 
Posts: 2
Joined: Thu 31 May 2012 13:35

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

Postby 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/revision_history.html
Pinturiccio
Devart Team
 
Posts: 1884
Joined: Wed 02 Nov 2011 09:44

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

Postby Pcx » Fri 01 Jun 2012 15:50

Tks for your prompt answer :wink:
Pcx
 
Posts: 2
Joined: Thu 31 May 2012 13:35

Previous

Return to dotConnect for Oracle