I missed the versions, sorry
July 26, 2017 - 1:42 am UTC
Reviewer: Saranga Colambage
Thank you for the response Chirs! And, sorry I couldn't mention the correct versions. It works until 126.96.36.199 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
June 25, 2020 - 5:48 pm UTC
Reviewer: Agustin Lozano from Colombia
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:
SELECT * FROM table
in this case all explain plan is using
my doubt is, how can avoid it?.... I mean, perhaps altering any parameter of database or session?
thanks in advance,
June 26, 2020 - 4:22 am UTC
I wish we did have such a parameter, but I also worry for how many apps would break under such conditions :-)