[Israel.pm] bind values are not working with oracle?
Yuval Yaari
yuval at windax.com
Thu Feb 8 21:59:04 EET 2007
rami doqa wrote:
> 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) );
>
Did you try tracing it? Something like:
$self->{dbh}->trace(2, "/tmp/dbi_log");
(Please note that you may have to increase the trace level, but I'd
start with 2 anyway).
For more information you should check "TRACING" in `perldoc DBI`.
HTH,
~Y
More information about the Perl
mailing list