I assume that begin atomic is equivalent to begin transaction in Oracle.
Also note that .marketplace is for job and product sales related postings,
your question really belongs in .server
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Legal disclaimer required by my employer
****************************************************************************
**
This email contains information intended for the addressee only.
It may be confidential and may be the subject of legal and/or professional
privilege.
Any dissemination, distribution, copyright or use of this communication
without prior permission of the addressee is strictly prohibited.
****************************************************************************
**
"CME" <support_at_cmesys.demon.co.uk> wrote in message
news:995551722.1464.0.nnrp-10.c2de4217_at_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 Tue Jul 31 2001 - 04:22:31 CDT
