Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02083: mv references PL/SQL function that maintains state
- 1 Answers
- 5013 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 |
NNL-00547: Displays rename request statistics
ORA-12525: TNS:listener has not received client's request in time allowed
ORA-19614: archivelog thread string sequence string not found in backup set
NID-00301: Datafile string - dbid changed, wrote new name
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-31467: no column found in the source table
ORA-28668: cannot reference mapping table of an index-organized table
ORA-06811: TLI Driver: could not set the IPX network number at init
NNL-00559: Shows, sets, or cancels the time for the next cache dump to the trace file
TNS-01016: change_password [<listener_name>]: changes the password of the listener
ORA-01262: Stat failed on a file destination directory
LRM-00110: syntax error at 'string'
Oracle Errors 
