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 |
ORA-02790: File name is too long
ORA-32012: failure in processing system parameters from restored SPFILE
ORA-13027: unable to read dimension definition from string
ORA-02287: sequence number not allowed here
NNL-00350: No save config currently scheduled
ORA-17506: I/O Error Simulation
ORA-38437: The ADT "string" may not contain any user methods.
ORA-30191: missing argument list
ORA-09214: sfdone: I/O error detected
ORA-16794: Database Guard is ON for primary database
ORA-08238: smsfre: cannot detach from SGA
NNL-00521: Shows or sets the server's system query forwarding requirements