QSM-02037: cannot evaluate constant expression at compile time
- 1 Answers
- 2461 Views
- I also Faced
- E-Mail Answers
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-22927: invalid LOB locator specified
ORA-31651: communication error with master process - detaching job
IMG-00899: signature cannot be generated
ORA-37122: AW Session cache disabled
RMAN-03034: LEVEL number is invalid. LEVEL must be between string and string
ORA-30338: illegal dimension hierachy name
ORA-29504: invalid or missing schema name
ORA-22920: row containing the LOB value is not locked
ORA-24313: user already authenticated
ORA-30478: Specified dimension does not exist
ORA-06793: TLI Driver: server cannot create new process
ORA-24813: cannot send or receive an unsupported LOB
Oracle Errors 
