首先,创建一个队列Sequence
-- Create sequence
create sequence PRIMARYKEYSEQUENCE
minvalue 0
maxvalue 999999999999999999999999999
start with 83
increment by 1
nocache;

然后,创建触发器Triggers
-- Create triggers
create or replace trigger XG_ATTENDANCETRIGGER
 before insert on xg_attendance 
 for each row
declare
 nextid number;
begin
 if:new.AID is null or:new.AID=0
 then
 select primarykeysequence.nextval into nextid from sys.dual;
 :new.AID:= nextid;
 end if;
end XG_ATTENDANCETRIGGER;

最后,在包Packages中创建存储过程Procedure
-- Create procedure
create or replace package body xg.AttendancePackage is
procedure proc_insertAttendance(wid in varchar2,inTime in varchar2,aid out varchar2)
is
begin
    insert into xg.xg_attendance(wid,aintime) values(wid,inTime);
    select xg.primarykeysequence.currval into aid from sys.dual;
end;
end AttendancePackage;

在ASP.NET中用企业库调用Oracle的存储过程