Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07585: spdcr: $PARSE failure

1 Answers  


RMAN-06732: database dropped

1 Answers  


ORA-02037: uninitialized speed bind storage

1 Answers  


O2U-00203: Type to be declared must be an object type or a named collection type

1 Answers  


ORA-16136: Managed Standby Recovery not active

2 Answers  






ORA-29885: domain index is defined on the column to be modified

1 Answers  


ORA-26001: Index string specified in SORTED INDEXES does not exist on table string

1 Answers  


ORA-16095: Dependent destination removal for inactivation

1 Answers  


ORA-38471: ROWIDs for table aliases cannot be null

1 Answers  


TNS-00007: INTCTL: unknown host

1 Answers  


ORA-30371: column cannot define a level in more than one dimension

1 Answers  


RMAN-06439: RMAN must be upgraded to version string to work with this package

1 Answers  






Categories