plsql创建存储过程无效是什么原因?
练习代码如下
create or replace PROCEDURE prodemo(param1 in VARCHAR2)
as
ageTemp "student".age%type;
begin
select age into ageTemp from "student" where id=param1;
update "student" set age=age+1 where id=param1;
dbms_output.put_line('去年的年龄是:' ||ageTemp|| ',今年的年龄是:' ||(ageTemp+1));
end;
