Hi,
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 anybody tell me what is wrong with this code,(the
statement handler inserts into the table)
cheers,
Mark
if (condition){
open (IN,$uniquefile) or die "Cannot Open $uniquefile \n";
$uniquemarker=<IN>;
close(IN);
$uniquemarker++;
$sth1->execute($uniquemarker,$var1,$var2) or die "Can't execute SQL
statement: $DBI::errstr\n";
}
open (OUT,">$uniquefile");
print OUT "$uniquemarker";
$dbh1->disconnect();
exit;
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
