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

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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02083：mv引用维护状态的PL / SQL函数,
.原因：当物化视图引用一个维护状态的PL / SQL函数时，不支持该问题的能力，并且每次对同一组行调用时可能不返回相同的值。,
.操作：重新排序查询以避免这样的PL / SQL函数。或者修改PL / SQL函数以避免状态维护并相应地更改其声明。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题