分析以下代码的错误并改正：create or replace procedure inuser ( resultStr out char, v_username in VARCHAR2, v_id_card in CHAR, v_password in CHAR ) is a number; b number; age number; temp number; Begin --请自行编辑存储过程函数体 a:=to_number(to_char(sysdate, 'yyyy' )); b:=to_number(to_char(substr('184659994544545',7,4))); age:=b-a; temp:=mod(to_number(to_char(substr(v_id_card,18))),2); if temp=0 then insert into userinfo (userid,username,password,uage,usex,uphone,uemail,id_card) values (userid.nextval,v_username,v_password,age,'女',v_uphone,v_uemail,v_id_card); ResultStr := 'success: 执行成功.'; return; else insert into userinfo (userid,username,password,UAGE,USEX,UPHONE,UEMAIL,ID_CARD) values （userid.nextval,v_username,v_password,age,'男',v_uphone,v_uemail,v_id_card); ResultStr := 'success: 执行成功.'; end if; End;
扫一扫
270
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
