c# - 使用游标和过程时连接关闭

Question

我的代码是-

        string oracleb = "Data source=HPPRO58; user ID=system; password=deb;";
        conn = new OracleConnection(oracleb);
        //conn.Open();
        conn.Open();
        String x3 = "google";
        String x1 ;
        String x2;
        String s1 = "delete from temp";
        OracleCommand comm = new OracleCommand(s1, conn);
        comm.ExecuteNonQuery();


        OracleCommand comm2 = new OracleCommand();
        String s2 = "cv";
        comm2.Connection = conn;
        comm2.CommandText = s2;
        comm2.CommandType = CommandType.StoredProcedure;
        comm2.Parameters.Add("x", System.Data.OracleClient.OracleType.Number).Value = comboBox1.Text;
        comm2.Parameters.Add("y", System.Data.OracleClient.OracleType.Number).Value = comboBox2.Text;
        comm2.Parameters.Add("z", System.Data.OracleClient.OracleType.Number).Value = x3;
        comm2.ExecuteNonQuery();

        String s3 = "select * from temp";
        OracleCommand comm3 = new OracleCommand(s3, conn);
        OracleDataAdapter MyAdapter3 = new OracleDataAdapter();//adapter acts as interface btw database and dataset(which is collectio of tables)
        MyAdapter3.SelectCommand = comm;
        DataTable dTable3 = new DataTable();//datatable represents a single table in database 
        MyAdapter3.Fill(dTable3);
        dataGridView1.DataSource = dTable3;
        conn.Close();

我的错误是-

我正在尝试运行一个也有游标的过程。因此我使用了 3 个通信变量。但是我收到了上述错误。因此我想知道如何解决它。

我在函数开始时打开了连接，但仍然显示连接已关闭。

编辑-

我的程序名称是 cv

新错误——

我的程序-

create or replace procedure cv(x in int,y in int,z in varchar)
as
cursor c
is
select email,collegename,cgpa,compname
from student_cv
where (cgpa>=x and yearsofexp>=y) and compname=z;
tem c%rowtype;
begin
open c;
loop
fetch c into tem;
exit when c%notfound;
insert into temp values(tem.email,tem.collegename,tem.cgpa,tem.compname);
end loop;
end;
/

第59行是-

comm2.Parameters.Add("x", System.Data.OracleClient.OracleType.Number).Value = comboBox1.Text;

标签： c#sqloraclevisual-studiooracle11g