Oracle Error QSM-02029: PL/SQL function invocation

Oracle Error Message

QSM-02029: PL/SQL function invocation

Reason for the Error

The capability in question is not supported when the materialized view invokes a PL/SQL function.

Solution

Re-phrase the query to avoid use of PL/SQL functions.