Loading

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

Дата публикации: Apr 28, 2025
Описание
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. 
Решение

Option 1: 

Use extract instead of a live connection.

Option 2: 

Redesign the join or custom SQL query to return fewer columns. 
Дополнительные ресурсы
ORA-01795: maximum number of expressions in a list is 1000 tips at DBA-Oracle.com
ORA-01795, limit on clause at Oracle community
Номер статьи базы знаний

001473236

 
Загрузка
Salesforce Help | Article