QSM-02083 materialized view references PL/SQL function that maintains state
March 20th, 2009
Description:
QSM-02083 materialized view references PL/SQL function that maintains state
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.
Either 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.