oracle自定义函数迁移到DB2,高手进来帮忙,多谢了
create or replace function GET_SEQ( seq_name in char, o_seq_v out numeric )
return int
AS
t_sqlstr varchar(100);
begin
t_sqlstr := 'select '||seq_name||'.nextval from dual';
execute immediate t_sqlstr into o_seq_v;
return(0);
exception
when OTHERS then
--dbms_output.put_line( sqlerrm );
rollback;
return(-1);
end GET_SEQ;
----------------------------------------------
CREATE OR REPLACE function P_GET_SEQ(IN i_seq_name char(20),OUT o_seq_v
double )
returns integer
LANGUAGE SQL
begin
DECLARE t_sqlstr varchar(100) default '';--
SET t_sqlstr = 'select nextval for '||i_seq_name||' from syspublic.dual';--
execute immediate t_sqlstr;--
/*异常怎么处理*/ return(0);--
end