Getting error "invalid number" when trying to do insert statement (4254554)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Getting error "invalid number" when trying to do insert statement
Description

Have an insert statement that gets numeric data into a numeric column based on a VARCHAR column that contains both numeric and character values. The query makes sure only numeric characters are passed. There are 2 laptops, both running Windows 7 and Toad for Oracle, one runs the insert statement fine, the other one fails with "invalid number".
Resolution

RESOLUTION 1:

Check for the oracle client that both laptop are using. Connect to the database with Toad and go to the Help | support bundle on both laptop to see if they are using the same oracle client.

RESOLUTION 2:

Being that there are two laptop with the same setup and one is working, try to copy the Toad.ini file from the working laptop to the one that is not working.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title