hey

i had an issue in both the test and prod database where the TO_NUMBER function behaves differently depending on data.
I was just running explain plan for the same code using different oracle accounts and got different results.

Can someone help me with this?

is there anything on the database configuraton I need to check.
this is a prob since we moved form server A to server B.

Thanks