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

PLS-00801: internal error [string]

1 Answers  


ORA-22605: FDO handle [string] is not initialized

1 Answers  


ORA-23327: imported deferred rpc data does not match string of importing db

1 Answers  


LPX-00236: invalid character ~1u ('~2c') found in public identifier

1 Answers  


ORA-12593: TNS:no registered connection

1 Answers  






ORA-29824: operator is invalid

1 Answers  


ORA-38434: could not evaluate expression "string"

1 Answers  


ORA-34722: (NLSCHARSET05) CAUTION: Character data loss in character set conversion from string to string

1 Answers  


PLS-00993: Cursor Variables cannot be passed as RPC arguments or results

1 Answers  


DRG-10553: illegal syntax for column specification string

1 Answers  


ORA-16523: Operation requires the client to connect to instance "string".

1 Answers  


KUP-02003: unrecognized character: string

1 Answers  


Categories