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 |
TNS-12233: TNS:Failure to accept a connection
NNL-00899: OK responses sent: number
PLS-00359: assignment target in 'string' must have components
ORA-16055: FAL request rejected
ORA-01519: error while processing file 'string' near line string
RMAN-03032: this option of set command needs to be used outside of a run block
IMP-00080: Error during character conversion of long column or long command
ORA-01783: only one RECOVERABLE or UNRECOVERABLE clause may be specified
ORA-22294: cannot update a LOB opened in read-only mode
ORA-32034: unsupported use of WITH clause
ORA-01209: data file is from before the last RESETLOGS
DRG-10800: query failed: string string string