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: 247

Filed under:
|
|

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

Related posts about perl

Related posts about Oracle