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 |
LPX-00248: invalid entity declaration
DRG-11213: CTXSYS does not own procedure filter stored procedure: string
ORA-30362: dimension column cannot be a sequence
ORA-00323: Current log of thread string not useable and all others need archiving
ORA-30656: column type not supported on external organized table
ORA-32318: cannot rename a materialized view
ORA-13408: invalid blockSize storage parameter
ORA-25129: cannot modify constraint (string) - no such constraint
PLS-00313: 'string' not declared in this scope
DRG-12900: Operation:string for index: string has already been started
TNS-01013: set|show trc_{ } [<value>]: set|show trace parameters of current listener
ORA-27419: unable to determine valid execution date from repeat interval