QSM-02037: cannot evaluate constant expression at compile time
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-08103: object no longer exists
ORA-31222: DBMS_LDAP: PL/SQL - Invalid LDAP SSL authentication mode.
ORA-16217: prepare to switchover has not completed
RMAN-06158: validation succeeded for archived log
TNS-01178: Trace Level is 0. Trace file/directory unchanged
EXP-00099: Table "string"."string" is not in a valid state, table will not be exported
IMG-00554: extra value in rotate operation
ORA-00225: expected size string of controlfile differs from actual size string
PLS-00995: unhandled exception # string
ORA-31628: error getting worker process exception
LRM-00114: error when processing from command line
ORA-32143: Environment not specified