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

ORA-19578: end of volume while duplexing to sequential files, backup piece incomplete

1 Answers  


ORA-14187: partitioning method for LOCAL index is inconsistent with that of the underlying table

1 Answers  


TNS-12522: TNS:listener could not find available instance with given INSTANCE_ROLE

1 Answers  


ORA-32331: type "string"."string" is incompatible with the master site

1 Answers  


ORA-07492: scgrcl: cannot close lock.

1 Answers  






ORA-12855: cannot run parallel or insert direct load in a loopback

1 Answers  


ORA-36996: (XSRELGID13) Valueset workspace object should be defined over dimension workspace object.

1 Answers  


TNS-12211: TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA

1 Answers  


TNS-00545: parameter retrieval failure

1 Answers  


ORA-12452: label tag string already exists

1 Answers  


ORA-00303: cannot process Parallel Redo

1 Answers  


RMAN-08039: channel string: starting incremental datafile backupset restore

1 Answers  


Categories