How to convert "Begin Atomic" in Sybase to Oracle !!!

From: CME <support_at_cmesys.demon.co.uk>
Date: Thu, 19 Jul 2001 15:07:51 +0100
Message-ID: <995551722.1464.0.nnrp-10.c2de4217@news.demon.co.uk>

HI:

Would you like to tell me how i can convert the following case in Sybase format to Oracle?

---

create or replace procedure
bbc.AddNewIdentInformed(sDateDone in date,sPerson in long,sDoneBy in long,sNotes in long,sIdentID in number,sID out number) begin atomic
  insert into IdentInformed(IdentID,DateDone,Person,DoneBy,Notes) values(     sIdentID,sDateDone,sPerson,sDoneBy,sNotes);   select MAX(ID) into sID from IdentInformed; end;
/

---

Thanks! Received on Thu Jul 19 2001 - 09:07:51 CDT