select seq_info_id.currval from dual;如果是在存储过程里面
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;
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;
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;
end ;
select 序列.currval into p_out from dual;
--然后在C#中执行过程,得到p_out返回值.