.net调用oracle带返回值存储过程的问题

Question

下面是存储过程。。如何在.net中调用？？
CREATE OR REPLACE PROCEDURE GetScheduleGivenDay (
  GivenDay date)
is
task_title  task.title%type;
task_detail  task.detail%type;
task_begintime  task.begintime%type;
task_notifytime  task.notifytime%type;
task_neednotify  task.neednotify%type;
task_finished  task.finished%type;
tasktype_typetitle  tasktype.typetitle%type;
priority_prioritytitle  priority.prioritytitle%type;begin
select
  task.title,
  task.detail,
  task.begintime,
  task.notifytime,
  task.neednotify,
  task.finished,
  tasktype.typetitle,
  priority.prioritytitle
into 
  task_title, 
  task_detail, 
  task_begintime, 
  task_notifytime, 
  task_neednotify, 
  task_finished, 
  tasktype_typetitle, 
  priority_prioritytitle 
from task,tasktype,priority
where to_char(GivenDay,'yyyy-mm-dd')=to_char(BEGINTIME,'yyyy-mm-dd');
end GetScheduleGivenDay;
下面是我的.net的代码，不知道哪里错了，搞了两天了，高手帮帮忙解决下，谢谢了。
         public bool GetScheduleByGivenDay(ref OracleConnection myConn,ref DataSet ds,ref DateTime GivenDay)
            {
                OracleDataAdapter da=new OracleDataAdapter("GetScheduleByGivenDay",myConn);
                da.SelectCommand.CommandType=CommandType.StoredProcedure;
                da.SelectCommand.Parameters.Add("GivenDay", GivenDay);
                try
                {
                    da.Fill(ds,"ScheduleList");
                }
                catch
                {
                    return false;
                }                return true;
            }        private void button1_Click(object sender, EventArgs e)
        {
            DateTime GivenDay = DateTime.Parse(SelectDay.Value.ToString());
            Fill_dayview(GivenDay);
        }
   
        private int Fill_dayview(DateTime GivenDay)
        {
           
            //生成一个新的DataSet
            DataSet DS_DayView = new DataSet();
            MySchedule DaySchedule = new MySchedule();
            if (!DaySchedule.GetScheduleByGivenDay(ref myConn, ref DS_DayView, ref GivenDay))
                return -1;
            int nScheduleCount = DS_DayView.Tables["ScheduleList"].Rows.Count;
            dg_dayview.DataSource = DS_DayView.Tables["ScheduleList"].DefaultView;
            return 0;
           
        }

Answer 1

下面是存储过程。。如何在.net中调用？？
CREATE OR REPLACE PROCEDURE GetScheduleGivenDay (
  GivenDay date)
is
task_title task.title%type;
task_detail task.detail%type;
task_begintime task.begintime%type;
task_notifytime task.notifytime%type;
task_neednotify task.neednotify%type;
task_finished task.finished%type;
tasktype_typetitle tasktype.typetitle%type;
priority_prioritytitle priority.prioritytitle%type;begin
select
  task.title,
  task.detail,
  task.begintime,
  task.notifytime,
  task.neednotify,
  task.finished,
  tasktype.typetitle,
  priority.prioritytitle
into  
  task_title,  
  task_detail,  
  task_begintime,  
  task_notifytime,  
  task_neednotify,  
  task_finished,  
  tasktype_typetitle,  
  priority_prioritytitle  
from task,tasktype,priority
where to_char(GivenDay,'yyyy-mm-dd')=to_char(BEGINTIME,'yyyy-mm-dd');
end GetScheduleGivenDay;