[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`.

HTH,

  ~Y



More information about the Perl mailing list