Loading

Error "Oracle database error 1795: ORA-01795: maximum number of expressions in a list is 1000 "

Date de publication: Apr 28, 2025
Description
When you try to create a join or open a workbook containing custom SQL, the following error might occur: 
Oracle database error 1795: ORA-01795: maximum number of expressions in a list is 1000

Cause

Error 1795 is a message from the Oracle database which is returned when more than 254 columns are specified to a list. 
Résolution

Option 1: 

Use extract instead of a live connection.

Option 2: 

Redesign the join or custom SQL query to return fewer columns. 
Ressources supplémentaires
ORA-01795: maximum number of expressions in a list is 1000 tips at DBA-Oracle.com
ORA-01795, limit on clause at Oracle community
Numéro d’article de la base de connaissances

001473236

 
Chargement
Salesforce Help | Article