Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02083: mv references PL/SQL function that maintains state
- 1 Answers
- 4941 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-12404: invalid privilege string: string
ORA-07713: sksamtd: could not mount archival device (SYS$MOUNT failure)
ORA-02762: file number to be cancelled is greater than the maximum.
ORA-12090: cannot online redefine table "string"."string"
NZE-29031: SSL handshake is required.
PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names
ORA-07549: sftopn: $OPEN failure
ORA-09969: scurls: unable to close lock file
RMAN-02007: Integer value overflow
PLS-01455: The predicates IS NULL and IS NOT NULL are defined only for column specifications
DRG-10100: invalid argument found: string
ORA-28151: more than one user name specified for command
Oracle Errors 
