PLS-00103: 出现符号 "IN"在需要下列之一时，创建过程时报错

Question

CREATE OR REPLACE PROCEDURE sp_test8(in monthe int,out season varchar) is
begin
case
when monthe >=1 and monthe<=3 then
set season='spring';
when monthe >=4 and monthe<=6 then
set season='summer';
when monthe >=7 and monthe<=9 then
set season='autumn';
when monthe >=10 and monthe<=12 then
set season='winter';
end case;
exception
when others then
dbms_output.put_line('该季节不存在');
end sp_test8;

PROCEDURE TCMP.SP_TEST8 编译错误

错误：PLS-00103: 出现符号 "IN"在需要下列之一时：

current delete exists
prior
行：1
文本：CREATE OR REPLACE PROCEDURE sp_test8(in monthe int,out season varchar) is

Answer 1

in和out的位置不对

CREATE OR REPLACE PROCEDURE sp_test8( monthe in int,season out  varchar)

另外，oracle不建议使用varchar，而应该使用varchar2