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-01722: invalid number error coming in Oracle 10g.

SISSep 1 2008 — edited Sep 1 2008

Hi,

We are getting the error "ORA-01722: invalid number" while opening a cursor using CURSOR FOR LOOP.

This error has started coming only after we have migrated to Oracle 10g from Oracle 9i. Earlier the same code used to work properly. And also on Oracle 10g, its not happening every time. Sometimes it gives error while sometimes it works.

Does anybody know about any such bug in Oracle 10g. Our cursor is a parametrized cursor accepting a VARCHAR2 parameter and the value we are passing to it is also character.

Our database is Oracle 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production and is running on UNIX server.

This post has been answered by Billy Verreynne on Sep 1 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 29 2008

Added on Sep 1 2008

4 comments

3,071 views