create or replace procedure AAA
(RESULT OUT CHAR)
ASTEMP1 CHAR(10);
TEMP2 CHAR(4);BEGIN
select lpad(sequence.nextval,6,'0') into temp1 from dual;
select to_char(sysdate,'yy') into temp2 from dual;
result:=temp1 || temp2;
END;上述代码总是出错,提示参数数量或类型不对,不知是何原因???
(RESULT OUT CHAR)
ASTEMP1 CHAR(10);
TEMP2 CHAR(4);BEGIN
select lpad(sequence.nextval,6,'0') into temp1 from dual;
select to_char(sysdate,'yy') into temp2 from dual;
result:=temp1 || temp2;
END;上述代码总是出错,提示参数数量或类型不对,不知是何原因???
(RESULT OUT CHAR)
ASBEGIN
declare TEMP1 CHAR(10);
declare TEMP2 CHAR(4);
select lpad(sequence.nextval,6,'0') into temp1 from dual;
select to_char(sysdate,'yy') into temp2 from dual;
result:=temp1 || temp2;
END;
(RESULT OUT CHAR)----> 改为(Result out varchar)
试试
把分给他们吧
ll7777(游魂野鬼) ( ) 信誉:
smilelhh(blue) ( ) 信誉: