Hi everybody. Can any one help me please why binding
values are not working with oracle?
My example:
my $x = 100;
my $y ='blabla';
# this is not working:
my $sql = "SELECT xy FROM tableName WHERE x =? AND y
=?";
$self->{dbh}->selectrow_array( $sql, undef, ($x,$y) );
# tnis code is working fine:
my $sql = "SELECT xy FROM tableName WHERE x =$x AND y
='$y'";
$self->{dbh}->selectrow_array($sql);
____________________________________________________________________________________
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html
_______________________________________________
Perl mailing list
[email protected]
http://perl.org.il/mailman/listinfo/perl
