Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02083: mv references PL/SQL function that maintains state
- 1 Answers
- 4983 Views
- I also Faced
- E-Mail Answers
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 |
NNL-01009: Outbound message contexts freed: number
DRG-10700: preference does not exist: string
ORA-16006: audit_trail destination incompatible with database open mode
DRG-50610: internal error: string
ORA-13005: recursive HHCODE function error
ORA-30358: summary and materialized view are not in same schema
PLS-00519: This INSERT statement requires a VALUES clause containing an object type expression, not a list of values
ORA-07442: function address must be in the range string to string
ORA-32608: missing INCREMENT or DECREMENT keyword in FOR loop
PCC-01015: Cannot equivalence PIC N variable string
ORA-28233: double encryption not supported
ORA-07390: sftopn: translate error, unable to translate file name.
Oracle Errors 
