Unable to execute an oracle update statement within perl
Posted
by
Gunnlaugur
on Stack Overflow
See other posts from Stack Overflow
or by Gunnlaugur
Published on 2012-03-20T17:27:12Z
Indexed on
2012/03/20
17:29 UTC
Read the original article
Hit count: 246
I have a problem in a perl script that I'm writing. When I run the script it hangs after prepare(). I've tried to run the update statement from SQL Developer and it works fine.
I've also tried to print out all parameters and they are correct.
What am I missing here?
my $upd = 'update ngs.pp_subscr_data set address=?, city=?, postalcode=?, kennitala=?, email=?, firstname=?, lastname=?, last_upd=systimestamp where snb=?';
my $s = $dbh->prepare ($upd) || exitError(-9802, 'Couldn\'t prepare update statement.');
$s->execute($addr, $city, $pcode, $ktala, $email, $fname, $lname, $snb)
Thanks.
© Stack Overflow or respective owner