I always that the binding undef's in DBD::Oracle was the way to bind a null, yet:

DB<5> x $dbh->selectall_arrayref('select x,b from tbl where a=?', undef, 4)
0  ARRAY(0x9b53010)
   0  ARRAY(0x9ba6284)
      0  'bbc0dfec7ba578f2dafc8f2eb42fbd3ae17cf300'
      1  undef

but

DB<3> x $dbh->selectall_arrayref('select x,b from tbl where a=? and b=?', undef, 4, undef)
0  ARRAY(0x9ba0530)
     empty array

i.e. the 'b=?' in the statement where I bind the value to undef does _not_ act like
'b is null'.

Didn't this used to work?  I've tried this with DBD::Oracle v1.16 and 1.17.

-P

Reply via email to