[Israel.pm] bind values are not working with oracle?

Yuval Yaari yuval at windax.com
Thu Feb 8 11:59:04 PST 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`.



More information about the Perl mailing list