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 |
LSX-00114: facet "~S" not in schema schema
ORA-16740: log transport service for standby "string" incorrectly set to ALTERNATE.
ORA-24433: This statement has already been prepared using OCIStmtPrepare2.
ORA-27038: created file already exists
TNS-00288: Navigator: Failed to Disable Interchange
ORA-23531: site owner already exists in the template.
ORA-01371: Complete LogMiner dictionary not found
ORA-06253: NETNTT: cannot read arguments from address file
ORA-39307: the operation is illegal without an initial clone
ORA-02004: security violation
EXP-00080: Data in table "string" is protected. Using conventional mode.
ORA-08277: Cannot set environment variable