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
Last Modified Date: 01 Oct 2018
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.Additional Information
Error "ORA-24920:column size too large for client at OCI call OCIStmtFetch" by support.oracle.com
12c VARCHAR2(32767) by peasland.net
Note: While we make every effort to keep references to third-party content accurate, the information provided might change without notice.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials