KNOWLEDGE BASE

Error: Oracle database error 24920: ORA-24920: column size too large for client


Published: 28 Sep 2018
Last Modified Date: 01 Oct 2018

Issue

When attempting to connect to an Oracle data source that contains an extended VARCHAR2(32767) data type, the following error occurs:

Oracle database error 24920: ORA-24920: column size too large for client

Environment

  • Tableau Desktop
  • Oracle

Resolution

A possible workaround is to use a Custom SQL Query in Tableau Desktop to cast the Extended Data Type as a VARCHAR2(4000). This is discussed further in the following Tableau Community post which pertains to CLOB data types. 

Cause

The ability to connect to Extended VARCHAR2(32767) data types from an Oracle database in Tableau Desktop is currently not built into the product.
Did this article resolve the issue?