QSM-02037: cannot evaluate constant expression at compile time



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

Post New Answer

More Oracle Errors Interview Questions

LPX-00248: invalid entity declaration

1 Answers  


DRG-11213: CTXSYS does not own procedure filter stored procedure: string

1 Answers  


ORA-30362: dimension column cannot be a sequence

1 Answers  


ORA-00323: Current log of thread string not useable and all others need archiving

1 Answers  


ORA-30656: column type not supported on external organized table

1 Answers  






ORA-32318: cannot rename a materialized view

1 Answers  


ORA-13408: invalid blockSize storage parameter

1 Answers  


ORA-25129: cannot modify constraint (string) - no such constraint

1 Answers  


PLS-00313: 'string' not declared in this scope

1 Answers  


DRG-12900: Operation:string for index: string has already been started

1 Answers  


TNS-01013: set|show trc_{ } [<value>]: set|show trace parameters of current listener

1 Answers  


ORA-27419: unable to determine valid execution date from repeat interval

2 Answers  


Categories