学步园

我在用asp.net调用oracle存储过程的时候报ORA-06550错误.

create or replace procedure Proc_PaperDetail

(

  outid out   PAPER.PID % type

)

is

x varchar2(1200);

y varchar2(1200);

v_id number;

begin

select wm_concat(QID),replace(wm_concat(QANSWER),',','')into x,y

from (select QID,QANSWER from QUESTION where rownum <= 10 order by dbms_random.value   );

select sqe_paper.nextval into v_id from dual;

insert into PAPER values (v_id,x,y);

outid := v_id;

commit;

end Proc_PaperDetail;

public override string CallProcedure(string name)<br /> {<br /> //throw new NotImplementedException();<br /> // OracleParameter param = new OracleParameter("pid", OracleType.Number) ;<br /> // param.Direction = ParameterDirection.Output;<br /> OracleCommand cmd = new OracleCommand();<br /> OracleConnection conn = new OracleConnection();<br /> conn.ConnectionString = this.connString;<br /> cmd.Connection = conn;<br /> cmd.CommandType = CommandType.StoredProcedure;<br /> cmd.CommandText = name;<br /> cmd.Parameters.Add("outid", OracleType.Number);<br /> cmd.Parameters["outid"].Direction = ParameterDirection.Output;<br /> try<br /> {<br /> cmd.Connection.Open();<br /> int result = cmd.ExecuteNonQuery();<br /> return cmd.Parameters["outid"].Value.ToString();<br /> }<br /> catch (OracleException ex)<br /> {<br /> this._Message = ex.Message;<br /> return null;<br /> }<br /> finally<br /> {<br /> conn.Close();<br /> }</p> <p> }

只要参数跟存储过程的参数名相同,便不会报错.