我在用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;