SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06502 PL/SQLnumeric or value error character to number conversion error

848490Mar 31 2011 — edited Apr 6 2011

Hi,

I have written report in FastReport and I am using "Oracle Provider for OLE DB" for Oracle connection.

I have seen that my report throws oracle exception in some machines , so I analysed my PL/SQL and saw that problem occurs in "TO_NUMBER" function. (if i remove it exception does not occur)

However, same report works fine in another machine with the same data (same oracle provider version).

What can be the problem? What can be the dependence?

Thanks in advance

Elshan

p.s. Oracle provider version is 11.2.0.2.0

Locked Post

New comments cannot be posted to this locked post.

Locked on May 4 2011

Added on Mar 31 2011

#11g, #error, #plsql

5 comments

1,826 views