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 |
PLS-00801: internal error [string]
ORA-22605: FDO handle [string] is not initialized
ORA-23327: imported deferred rpc data does not match string of importing db
LPX-00236: invalid character ~1u ('~2c') found in public identifier
ORA-12593: TNS:no registered connection
ORA-29824: operator is invalid
ORA-38434: could not evaluate expression "string"
ORA-34722: (NLSCHARSET05) CAUTION: Character data loss in character set conversion from string to string
PLS-00993: Cursor Variables cannot be passed as RPC arguments or results
DRG-10553: illegal syntax for column specification string
ORA-16523: Operation requires the client to connect to instance "string".
KUP-02003: unrecognized character: string