Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to convert "Begin Atomic" in Sybase to Oracle !!!
Since Oracle doesn't have the identity feature of Sybase, you would need to create a sequence for your ID value and use it as part of your insert statement.
Mike
CME wrote:
> 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:21:49 CDT