Inserting in database table...

rgunturu_at_wsi.eecs.uic.edu (Rajasekhar Gunturu) wrote:

> I am facing problems inserting record(s) in a database table.
 

> I keep getting the error:  

> ORA 00664: sql error, at recursive level1
> ORA 01722: INVALID NUMBER
 
> All the entries in the record match their defintion(s)...., so I don't
> think it is due to a bad entry type.
 

> I get the same error both on Forms4.0(INVALID NUMBER EXCEPTION) and the SQL*Plus shell.
 

> any help in this regard appreciated...
 

> thanks,
> raj
 

> PS: The table is part of an heirarchical structure, inheriting foreign
> keys from two other tables.

You're probably referencing a NUMBER column using a non numeric value as a foreign key. Other common source for this kind of error is an unhandled exception in a database trigger, but I think the former one is more likely to be the case.

Best regards Received on Thu Sep 28 1995 - 00:00:00 CET