Loading

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

Udgivelsesdato: Apr 28, 2025
Beskrivelse
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. 
Løsning

Option 1: 

Use extract instead of a live connection.

Option 2: 

Redesign the join or custom SQL query to return fewer columns. 
Vidensartikelnummer

001473236

 
Indlæser
Salesforce Help | Article