Is there a reason for doing it this way? The main problem that might come
up here is if more than one instance of this script could run at close to
the same time. If this gets kicked of by some random(ish) event, like a
user signing in or something, then you can have several scripts read the
num
I'm not sure what is causing the problem in your case, but I have afew
comments.
1. Use Oracle sequences for the unique key unless you have a good reason not
to. What you are trying to do is already built into Oracle, no need to
invent your own way to do it.
[In Oracle SQL*Plus or other tool]
/
From: Mark Martin <[EMAIL PROTECTED]>
> I'm trying to maintain a unique key in an Oracle Table while working on the
> table using DBI. the unique key is just a no. read in from a txt file and
> incremented for each record - supposedly. In fact I'm getting unique
> constraint violation. Can anybod
