Hardy Merrill [mailto:[EMAIL PROTECTED] wrote: > > Just in case the op doesn't make the connection, he needs to test his > variables for undef before the execute, and if one is undef, then put > null("") in it, something like this: > > if (!defined($a)) {$a = "";} > if (!defined($b)) {$b = "";} > ... and so on - you get the idea... > $sth=$dbh->prepare(insert into OPER_QUERY values (?,?,?,?,....?) > ) > $sth->execute($a,$b,$c,$d,...$x) or die;
Why does he need to do that? I have never had to test my bind values for defined-ness when using placeholders. An undef in Perl becomes a NULL in Oracle, and vice versa. Ronald