[php]
PROCEDURE NewStat(
I_STATTYPE IN VARCHAR2,
O_ID OUT VARCHAR2
)
IS
v_ID NUMBER;
BEGIN
SELECT SEQ_stat.NEXTVAL INTO v_ID FROM dual;
insert into tstat
(
ID ,
STAT_TYPE ,
BEGIN_DATE ,
END_DATE ,
STAT_DATE ,
dept_id ,
LZJPC ,
XZJPC ,
LZJQX ,
XZJQX ,
INSIDEPC ,
XINSIDEPC ,
INSIDEQX ,
XINSIDEQX ,
GDCD ,
GDNL ,
ZGDLPC ,
ZGDLDGL ,
ZGDLXDS ,
PXDLPC ,
PXDGL ,
PXDLXDS ,
COUNTRY_PM_LEN ,
COUNTRY_PM_ABILITY
)
注:SELECT 'SEQ_stat'.NEXTVAL INTO v_ID FROM dual;
[/php]
提示:ORA-02289:sequence does not exist
PL/SQL:SQL Statement ignored