ORACLE不能执行这样子的函数吗?SQL codecreate or replace function Get_SeqIdreturn integerisV_SEQID IN
ORACLE不能执行这样子的函数吗?
SQL code
create or replace function Get_SeqIdreturn integeris V_SEQID INTEGER;begin update tab_autonumber set FLDCOUNTD = FLDCOUNTD + 1 where fldidnos = 'TB_BARSCANDATA' and FieldName = 'SEQID'; select FLDCOUNTD into V_SEQID from tab_autonumber where fldidnos = 'TB_BARSCANDATA' and FieldName = 'SEQID'; return V_SEQID;end Get_SeqId;
怎么在update tab_autonumber set FLDCOUNTD = FLDCOUNTD + 1 中会提示出错