$sql = select a , b , c from test where (a = :var1 and b = :var2) or (a = :var1 and c = :var3)
####
$sth->bind_param(':var1',$var1 , {ora_type=>ORA_VARCHAR2});
$sth->execute();
####
$sth->bind_param(':var1',$var1 , {ora_type=>ORA_VARCHAR2});
$sth->bind_param(':var1',$var1 , {ora_type=>ORA_VARCHAR2});
$sth->execute();