QSM-02037
cannot evaluate constant expression at compile time
Cause
The capability in question is not supported when the materialized view uses a compile-time non-constant expression in a filter condition in the WHERE or HAVING clauses. For example, WHERE X=1 uses a compile-time constant expression in a filter condition. WHERE X=MY_PLSQL_FUNCTION() uses a compile-time non-constant expression in a filter condition.
Action
Re-phrase the query to avoid the use of a compile-time non-constant expressions in filter conditions.
QSM-02037
cannot evaluate constant expression at compile time
Cause
The capability in question is not supported when the materialized view uses a compile-time non-constant expression in a filter condition in the WHERE or HAVING clauses. For example, WHERE X=1 uses a compile-time constant expression in a filter condition. WHERE X=MY_PLSQL_FUNCTION() uses a compile-time non-constant expression in a filter condition.
Action
Re-phrase the query to avoid the use of a compile-time non-constant expressions in filter conditions.
QSM-02037
cannot evaluate constant expression at compile time
Cause
The capability in question is not supported when the materialized view uses a compile-time non-constant expression in a filter condition in the WHERE or HAVING clauses. For example, WHERE X=1 uses a compile-time constant expression in a filter condition. WHERE X=MY_PLSQL_FUNCTION() uses a compile-time non-constant expression in a filter condition.
Action
Re-phrase the query to avoid the use of a compile-time non-constant expressions in filter conditions.