select vipcard_sequence.currval into v_temp1 from dual;
o_temp1 := v_vipcardid||substr(v_temp1,2,8);运行出错:vipcard_sequence.currval is not yet defined in this session请高手指点
o_temp1 := v_vipcardid||substr(v_temp1,2,8);运行出错:vipcard_sequence.currval is not yet defined in this session请高手指点
如果LAST_NUMBER=1就用nextval,此时的nextval=1;如果LAST_NUMBER<>1,
就用curval
试试行不!!!!
我这个sequence当前值是1706042010112936
在某个存储过程中开头用.currval时就会说没有定义
select last_number from all_sequences where sequence_owner=? and sequence_name=?