Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02083: mv references PL/SQL function that maintains state
- 1 Answers
- 5009 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-16011: Archivelog Remote File Server process in Error state
ORA-29818: column name not properly specified
ORA-34279: (MXDCL37) CONCAT can only be used when defining a DIMENSION.
TNS-00309: Connection Manager: Failed to open log while re-reading parameter data
PCC-02343: body of cursor must be a query expression
ORA-06793: TLI Driver: server cannot create new process
ORA-28290: Multiple entries found for the same Kerberos Principal Name
RMAN-12015: configuration for string channel number is ignored
PCC-02392: You are already in an EXEC SQL DECLARE SECTION
SQL*Loader-00800: %s specified and ignored
ORA-16955: Unknown error during SQL analyze.
ORA-16185: REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive
Oracle Errors 
