I missed the versions, sorry
Saranga Colambage, July 26, 2017 - 1:42 am UTC
Thank you for the response Chirs! And, sorry I couldn't mention the correct versions. It works until 11.2.0.3 and fails with the later. However, it seems and as you mentioned, the best (workaround) will be to change our bind variables... thanks again!
July 26, 2017 - 3:48 am UTC
glad we could help
regarding to implicit conversion of data
Agustin Lozano, June 25, 2020 - 5:48 pm UTC
Can I avoid implicit conversion in Oracle 12c or 19c by altering any parameter?, I mean, too many selects are trying to get data from columns NUMBER using WHERE like this:
column ID-->NUMBER
SELECT * FROM table
WHERE id='1234';
in this case all explain plan is using
WHERE id=TO_NUMBER('1234')
my doubt is, how can avoid it?.... I mean, perhaps altering any parameter of database or session?
thanks in advance,
AgustÃn
June 26, 2020 - 4:22 am UTC
Nope.
I wish we did have such a parameter, but I also worry for how many apps would break under such conditions :-)