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-00601: cleanup lock conflict
DRG-52204: error while registering index
IMP-00037: Character set marker unknown
NPL-00300: maximum ASN.1 element nesting depth string exceeded on read
ORA-09791: slembdf: translation error, unable to translate error file name.
ORA-01019: unable to allocate memory in the user side
ORA-13268: error obtaining dimension from USER_SDO_GEOM_METADATA
ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
TNS-01049: %s (string) has string service handler(s)
CLSS-02201: endpoint already in use: string
NCR-04022: NCRR: Invalid procedure descriptor
ORA-01112: media recovery not started