Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

NNO-00330: server saved the config file "string".

1 Answers  


ORA-02069: global_names parameter must be set to TRUE for this operation

1 Answers  


LPX-00241: entity reference is not well formed

1 Answers  


LSX-00250: invalid normalizedString "~S"

1 Answers  


ORA-24302: host connection in use by another thread

1 Answers  






ORA-16014: log string sequence# string not archived, no available destinations

1 Answers  


SQL*Loader-00909: Loader views must be loaded (as SYS) for direct path to be used

1 Answers  


ORA-22345: recompile type string.string before attempting this operation

1 Answers  


RMAN-20039: format requires character when duplexing

1 Answers  


ORA-00407: rolling upgrade from release string.string to string.string is not allowed

1 Answers  


ORA-30741: WITH HIERARCHY OPTION can be specified only for SELECT privilege

1 Answers  


ORA-12404: invalid privilege string: string

1 Answers  






Categories