ORA-01438: value larger than specified precision allows for this column

Okay, I've got an interesting issue:

I've got a table, opt, in which I've got the following fields: Opt_ID, Optics. The Opt_ID field is a foreign key linking to the Opt_ID field in an outer table. The Optics field is a table (O_tab) of type O_ty. The Opt_ID field is identifed as number(10), & the Optics field includes the fields OID & Opt. OID is identified as number(1), & Opt is number(10,10).

I'd like to insert the following info into this table:

Opt_ID number(10): 100
OID number(1): 1
Opt number(10,10): 1000

In order to do this, I'm inputting the following in iSQLPlus:

insert into opt (opt_id, optics)
values (100,
o_tab(
o_ty(1,1000)
));

I get the following error: "ORA-01438: value larger than specified precision allows for this column "

I get the impression that this error ought to indicate the information I'm inserting is incompatible with the identified format of the field. I've inserted info largely identical to this into other tables (including largely identical field layouts & identical insert commands) & I've not gotten this error. I'm at a loss..

Noel Whelan Received on Thu Jul 03 2003 - 17:01:37 CDT