Skip to Main Content

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!

Invalid number while inserting values into table

684511Apr 2 2009 — edited Apr 2 2009
Hi fellow humans..

I bet this will be quite a simple problem for most of you, but I've been trying for quite a while and I can't find my mistake.
Here's the table...

CREATE TABLE Joueur(
NoE INTEGER not null,
NoJ INTEGER not null,
NomJ VARCHAR2(80) NOT NULL,
Adresse VARCHAR2(80) NOT NULL,
Tel VARCHAR(20),
COJ VARCHAR(9) NOT NULL
);

I'll spare you the constraints...
The table creationg works well

Now here's the insert..

INSERT INTO JOUEUR VALUES(1,2,'Mirrione, Bastien','851 Rue Laurendeau','514-390-0579','X11944728');


I get the
[Error] Script lines: 1-1 --------------------------
ORA-01722: invalid number

Any ideas?
Much appreciated, thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2009
Added on Apr 2 2009
15 comments
1,070 views