KNOWLEDGE BASE

“Oracle database error 1722” Converting String to Integer


Published: 31 Jan 2013
Last Modified Date: 16 Aug 2017

Issue

When you use the INT() function on a text string, the following error occurs in Tableau Desktop:

Oracle database error 1722: ORA-01722: invalid number

Environment

  • Tableau Desktop
  • Oracle database

Resolution

Replace the Oracle data source with a full extract of the Oracle data source.

Cause

This error is caused by the Oracle database when it is unable to convert a character string into a valid number. For more information about this issue, refer to the following Oracle related documentation:
Did this article resolve the issue?