QSM-02083: mv references PL/SQL function that maintains state



QSM-02083: mv references PL/SQL function that maintains state..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-09764: osnmop: access error on oracle executable

1 Answers  


RMAN-06534: KEEP ... CONSISTENT option is not supported

1 Answers  


LSX-00231: invalid unsigned integer "~S"

1 Answers  


ORA-02717: osnpfs: incorrect number of bytes written

1 Answers  


ORA-14019: partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE

1 Answers  






ORA-19585: premature end of volume on piece string

1 Answers  


EXP-00021: can only perform incremental export in Full Database mode

1 Answers  


NID-00106: LOGIN to target database failed with Oracle error: string

1 Answers  


ORA-03002: operator not implemented

1 Answers  


ORA-16022: LOG_ARCHIVE_DEST cannot be NULL because LOG_ARCHIVE_DUPLEX_DEST is non-NULL

1 Answers  


ORA-01174: DB_FILES is string buts needs to be string to be compatible

1 Answers  


ORA-12525: TNS:listener has not received client's request in time allowed

1 Answers  


Categories