QSM-02083: mv references PL or SQL function that maintains state

QSM-02083: mv references PL or SQL function that maintains state

Cause: The capability in question is not supported when the materialized view references a PL or 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 or SQL function. Or modify the PL or SQL function to avoid state maintenance and change its declaration accordingly.

No comments:

Post a Comment