在C#种访问Oracle数据库存储过程,出现这个问题,代码如下:
public void newPlan()
        {
            planForm = new newPlanForm();//需要时生成;
            note = planForm.newPlanNote();
            OracleParameter noetPara=new OracleParameter("note",OracleType.VarChar);
            OracleParameter planID=new OracleParameter("newplanid",OracleType.Number);
            planID.Direction=ParameterDirection.Output;
            noetPara.Value = note;
            noetPara.Direction = ParameterDirection.Input;
            OracleCommand tempOraCmd = new OracleCommand("sp_newplan", new OracleConnection(this.planSqlCmd.retConnectString()));
            tempOraCmd.CommandType = CommandType.StoredProcedure;
            tempOraCmd.Parameters.Add(noetPara);
            tempOraCmd.Parameters.Add(planID);
            tempOraCmd.Connection.Open();
            tempOraCmd.ExecuteNonQuery();
            tempOraCmd.Connection.Close();
            this.planID= (int)(planID.Value);
        }