Loading

“Oracle database error 1722” Converting String to Integer

Julkaisupäivä: Feb 21, 2025
Kuvaus

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

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:
Ratkaisu

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

Extract Your Data

Lisäresurssit

Knowledge-artikkelin numero

001473558

 
Ladataan
Salesforce Help | Article