问题遇到的现象和发生背景
初学存储过程
问题相关代码,请勿粘贴截图
CREATE OR REPLACE PROCEDURE insert_student(
sno1 student.sno%TYPE,
sname1 student.sname%type,
ssex1 student.ssex%type,
sbirthday1 student.sbirthday%type,
classno1 student.classno%TYPE)
as
begin
INSERT INTO student(sno,sname,ssex,sbirthday,classno) VALUES(sno1,sname1,ssex1,sbirthday1,classno1);
end insert_student;
exec insert_student('20001144','吕图','男',TO_DATE('2001-4-12','4个Y-MM-DD'),'2006');//不让输4个Y
运行结果及报错内容
我的解答思路和尝试过的方法
各种