java - ORA-01858: a non-numeric character was found where a numeric was expected in Oracle ADF -
why above sql error oracle via java application query?
select * testschema.testtable userid = :userid , transactiondate between to_date(:start_date, 'yyyy-mm-dd') , to_date(:end_date,'yyyy-mm-dd')
i figured out. in example, there no need to_date
functions on start_date
, end_date.
worked fine:
select * testschema.testtable userid = :userid , transactiondate between :start_date , :end_date
Comments
Post a Comment