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

LSX-00114: facet "~S" not in schema schema

1 Answers  


ORA-16740: log transport service for standby "string" incorrectly set to ALTERNATE.

1 Answers  


ORA-24433: This statement has already been prepared using OCIStmtPrepare2.

1 Answers  


ORA-27038: created file already exists

1 Answers  


TNS-00288: Navigator: Failed to Disable Interchange

1 Answers  






ORA-23531: site owner already exists in the template.

1 Answers  


ORA-01371: Complete LogMiner dictionary not found

1 Answers  


ORA-06253: NETNTT: cannot read arguments from address file

1 Answers  


ORA-39307: the operation is illegal without an initial clone

1 Answers  


ORA-02004: security violation

1 Answers  


EXP-00080: Data in table "string" is protected. Using conventional mode.

1 Answers  


ORA-08277: Cannot set environment variable

1 Answers  


Categories