Receiving SQL error message: ORA-01722

1142715 pts.
Tags:
Oracle
SQL
In Oracle / SQL, I keep getting an error message when I'm trying to an insert. Here's the message: ORA-01722: Invalid number error. What does that mean? What can I do about it?
INSERT INTO CUSTOMER VALUES (1,'Michael','Claire','27 Smith St Caulfield','0419 853 694');
INSERT INTO CUSTOMER VALUES (2,'Johnson','Jake','27 Smith St Caulfield','0415 713 598');
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

It means that one of the columns in the table is numeric, but you are trying to insert a string that cannot be converted to a number automatically.

You have to review your table’s columns’ data types and insert correct data.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Without the table definitions, we can't say anything beyond what the error message says.
    35,070 pointsBadges:
    report
  • AjitK29
    Check your table definition and compare with your input statements.
    2,545 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: