Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02083: mv references PL/SQL function that maintains state
- 1 Answers
- 5002 Views
- I also Faced
- E-Mail Answers
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 |
TNS-00559: load of Entrust certificate failed
ORA-24143: invalid evaluation context name
ORA-13212: failed to compare tile with the window object
ORA-31518: change column string already exists in CDC change table string.string
ORA-16078: media recovery disabled
ORA-14553: cannot perform a lob write operation inside a query
ORA-13153: invalid high water mark specified
ORA-13009: the specified date string is invalid
ORA-13377: invalid combination of elements with orientation
IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified
TNS-01008: version [<listener_name>] : get the version information of the listener
ORA-23412: master table's primary key columns have changed
Oracle Errors 
