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-07824: sspain: $SETIMR failure
NZE-29189: No entry found in OID
PLS-00529: Bad column name string in INSERT statement (must be an identifier)
LSX-00167: defining form of "~S" must occur at the top level
ORA-12440: insufficient authorization for the SYSDBA package
ORA-18002: the specified outline does not exist
LSX-00002: root element is not <schema>
ORA-07488: scgrcl: lock manager not initialized.
ORA-31513: unsupported column type specified in change table
ORA-36998: (XSRELGID15) LEVEL ORDER VALUESET workspace object and LEVEL RELATION workspace object have the different level dimensions.
ORA-14122: only one REVERSE or NOREVERSE clause may be specified
TNS-01162: Syntax error in the address resolved from the spawn alias: string