Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02083: mv references PL/SQL function that maintains state
- 1 Answers
- 5091 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 |
ORA-02031: no ROWID for fixed tables or for external-organized tables
IMG-00526: error parsing foreign image description
TNS-01064: Listener configuration changes will not be persistent
ORA-07620: smscre: illegal database block size
ORA-02161: invalid value for MAXLOGFILES
ORA-13616: The current user string has not been granted the ADVISOR privilege.
UDI-00003: all allowable logon attempts failed
QSM-01075: materialized view, string, does not support aggregate function, string
NNC-00427: server does not support this version of the protocol
ORA-24784: Transaction exists
ORA-34361: (MXDSS12) number other user reading
ORA-27155: could not execute file
Oracle Errors 
