Devart Forums

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();
            }
        }
    }
}

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;