Re: passing PL/SQL variables to SQL PLUS
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 4 Apr 2002 14:48:17 +0100
Message-ID: <3cac59a2$0$227$ed9e5944_at_reading.news.pipex.net>
Date: Thu, 4 Apr 2002 14:48:17 +0100
Message-ID: <3cac59a2$0$227$ed9e5944_at_reading.news.pipex.net>
[Quoted] "Eva Haiden" <eva.haiden_at_engnetworld.com> wrote in message
news:52046b21.0204021330.5011bd38_at_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?
[Quoted] 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 ******************************************Received on Thu Apr 04 2002 - 15:48:17 CEST