Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

QSM-02083

mv 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.


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.