Ora 01722 which column

Like this: Like Loading Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:. Email Address never made public. Follow Following. Smart way of Technology Join other followers. Sign me up. ORA invalid number Cause: The attempted conversion of a character string to a number failed because the character string was not a valid numeric literal. Only numeric fields or character fields containing numeric data may be used in arithmetic functions or expressions.

Only numeric fields may be added to or subtracted from dates. Action: Check the character strings in the function or expression. Check that they contain only numbers, a sign, a decimal point, and the character "E" or "e" and retry the operation.

Search BC Oracle Sites. Applies to: Oracle Receivables - Version See Also : Databases , Media Show details. If you want so I will past all 93 records.

See Also : Business Show details. You executed a SQL statement that tried to convert a string to a number , but it was. See Also : Tech Support Show details. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

Moderators: chulett , rschirm , roy. If the CBO would decide to filter the criterias vice versa, the query would fail with " ORA - : invalid numbers", because it will first convert the complete data of the column "c" to number - …. On checking on net from Oracle side: ORA invalid number. Cause: The attempted conversion of a character string to a number failed because the character string was not a valid numeric literal. ORA invalid number error is actually a fairly typical error in Oracle database.

It is an invalid number error that occurs during a failure when you convert a character string to a valid number. I have given the basic scenarios of producing the ORA error. Active Oldest Votes. Improve this answer. He asked "How to check which line or which value is causing this error" so I provided the code which can identify the problematic value and line number.

If he knows the problematic value s then it can easily be fixed. In the first case, I created the scenario. And in the second case, I am printing the problematic values. Both are done purposely to provide the exact solution. Subhroneel Subhroneel 3 3 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.