楼主想用一个Function通过传入一个sequence名称获取这个序列的下一个值么? 假如是这样的话,用动态sql.CREATE OR REPLACE Function GET_SEQUENCE(v_seq_name in varchar2)
Return number Is v_seq number; v_sqlstr varchar2(128); begin v_sqlstr:='select '||v_seq_name||'.nextval '||' from '||' dual'; execute immediate v_sqlstr into v_seq; return v_seq; END;
假如是这样的话,用动态sql.CREATE OR REPLACE Function GET_SEQUENCE(v_seq_name in varchar2)
Return number Is
v_seq number;
v_sqlstr varchar2(128);
begin
v_sqlstr:='select '||v_seq_name||'.nextval '||' from '||' dual';
execute immediate v_sqlstr into v_seq;
return v_seq;
END;
前面是年月