invalid number ORA-01722

[ktsrikanth]

Hi
I have a problem.
When i try to insert into the table i get an error saying that
DBD::Oracle::st execute failed: ORA-01722: invalid number (DBD ERROR: OCIStmtExecute)
i checked at the table description and also the data i am inserting into the table. They are numbers.
I do not know why i get this error.
Please help me

 

[MikeLacey]

Hi -- could you post the code that is causing the error please? Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.

 

[Guest_imported]

Convert the text value to a number before inserting.

 

[hmerrill]

Also, if you know what data is causing the error on the INSERT, post that as well.
Hardy Merrill
Mission Critical Linux, Inc.

http://www.missioncriticallinux.com