Skip to Main Content

Database Software

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-1722 Invalid number" error while runing a SQL script in SQL*Plus

106281Nov 23 2001
Hello,

I created a SQL script that is intended to populate tables with
baseline data. When I run the script in the SQL*Plus program
that comes with the Oracle 8.1.6 (client), I receive an "ORA-
1722 Invalid number".

The error always occurs when SQL*Plus tries to execute the
following SQL statement:

insert into components(db_ind,module_id,ext_compid,active) values
('cm',modules_seq.currval,1046682,'y');

The datatypes for the columns on the components table are as
follows:
db_ind varchar2(2);
module_id number;
ext_compid number;
active varchar2(1);

It seems that for some reason Oracle is having trouble
recognizing 1046682 as a number.

I also tried the following INSERT statements to see if that
would work:

insert into components(db_ind,module_id,ext_compid,active) values
('cm',modules_seq.currval,to_number('1046682'),'y');

insert into components(db_ind,module_id,ext_compid,active) values
('cm',modules_seq.currval,'1046682','y');

but I still receive the same error message

Is there some NLS setting(s) I need to modify so that Oracle
does not give me this error? Does anyone know the answer to
this problem?

Your help is greatly appreciated.

Oscar

(NOTE: I also receive this same error when trying run the
script in SQL Navigator and Toad programs)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2001
Added on Nov 23 2001
0 comments
277 views