在过程中定义一个输出变量
create or replace procedure proc_name (.....,p_out out number)
as
v_id;
begin
....
....
select 序列.currval into v_id from dual;
...
p_out:=v_id;
如果是在存储过程里面
insert into INFORMATION (ID , MODULE , DEPID , TITLE , BODY , MAKER , MAKEDATE) VALUES (SEQ_INFO_ID.NEXTVAL, sModule , nDepID , sTitle , sBody , sMaker , SYSDATE)
return id into v_id;