QSM-02083: mv references PL/SQL function that maintains state
Answer / guest
Cause: The capability in question is not supported when the
materialized view references a PL/SQL function that
maintains state and which may not return the same value
every time it is invoked against the same set of rows.
Action: Re-phrase the query to avoid such a PL/SQL function.
Or modify the PL/SQL function to avoid state maintenance and
change its declaration accordingly.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
LSX-00171: missing required sub-element "~S"
ORA-01879: the hh25 field must be between 0 and 24
DRG-11307: operation cannot be performed on an index
ORA-22804: remote operations not permitted on object tables or user-defined type columns
PCC-02402: Pro*C option OBJECTS=YES is required when using the object cache
ORA-12423: invalid position specified
SQL*Loader-00286: ROWS parameter is not supported when loading an IOT.
DRG-50900: text query parser error on line string, column string
ORA-28602: statement not permitted on tables containing bitmap indexes
ORA-16227: DDL skipped due to missing object
DRG-13309: operation not supported by USER_LEXER
PLS-00105: at most one forward declaration of type 'string' is permitted