go to bug id or search bugs for
I think there is a problem with binding variables with condition to Date columns in oracle sql.
It gives ORA-01722 invalid number. With numbers and varchars everything is ok.
Putting directly in sql without binding gives a result.
PHP Version 7.1.1
Oracle Run-time Client Library Version 18.104.22.168.0
TO_DATE(:ON_DATE,'YYYY-MM-DD') BETWEEN x.fromdate AND x.todate
$onDate = '2017-03-02';
oci_bind_by_name($stid, ":ON_DATE", $onDate)
Add a Patch
Add a Pull Request
I have found a reason of my troubles.
IN SQL was another condition:
AND upr.user_id = :USER_ID
I was binding not variable, but method result. ($User->getUserId()).
There is notice that I shouldn't do that.
This is the reason why next bind of date variable gives such error.
I think it shouldnt looks like this, its veery confusing.