Home » SQL & PL/SQL » SQL & PL/SQL » How to Bypass "ORA-01722: invalid number"
icon9.gif  How to Bypass "ORA-01722: invalid number" [message #421697] Wed, 09 September 2009 21:32 Go to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
I have a procedure that raises this error.

The problem is that it is very difficult to track where the data error occurs.

So, is there a way for me to make sure that the procedure will proceed with the rest of the data?

As the "ORA-00001: unique constraint (CRISPADM.PK6) violated" can?

Thank you... http://img01.picoodle.com/img/img01/3/11/1/aimy/f_tqm_bcc85fd.gif
Re: How to Bypass "ORA-01722: invalid number" [message #421698 is a reply to message #421697] Wed, 09 September 2009 21:46 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>I have a procedure that raises this error.

>is there a way for me to make sure that the procedure will proceed with the rest of the data?

Only process valid data by checking data before DML.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Previous Topic: How to convert Long to Varchar2 ?
Next Topic: ORA-00984: column not allowed here
Goto Forum:
  


Current Time: Fri Dec 09 02:08:28 CST 2016

Total time taken to generate the page: 0.10328 seconds