Path: news.easynews.com!easynews!newsfeed.frii.com!newsfeed.icl.net!colt.net!newspeer.clara.net!news.clara.net!oleane.net!oleane!bnewspeer00.bru.ops.eu.uu.net!bnewsifeed00.bru.ops.eu.uu.net!bnewsifeed01.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.tools References: <52046b21.0204021330.5011bd38@posting.google.com> Subject: Re: passing PL/SQL variables to SQL PLUS Date: Thu, 4 Apr 2002 14:48:17 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 26 Message-ID: <3cac59a2$0$227$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: host9.audit-commission.gov.uk X-Trace: 1017928098 reading.news.pipex.net 227 193.128.236.219 X-Complaints-To: abuse@uk.uu.net Xref: easynews comp.databases.oracle.tools:50395 X-Received-Date: Thu, 04 Apr 2002 06:46:06 MST (news.easynews.com) "Eva Haiden" wrote in message news:52046b21.0204021330.5011bd38@posting.google.com... > We don't have and do not want to install a sequence on the id column. why not? trigger/sequence is the ideal combo for this. Question: what happens if a user runs your script and doesn't commit before the next time the script is run? Answer: you get an attempt to insert the same id twice. This will not happen with a trigger/sequence. -- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************