DBA Data[Home] [Help]

SYS.DBMS_SNAPSHOT dependencies on EXPLAINMVARRAYTYPE

Line 425: msg_array IN OUT SYS.ExplainMVArrayType);

421: -- Alternatively, specify an existing materialized view by giving the name
422: -- and the schema in which the materialized view was created ([schema.]mvname)
423: -- The output is placed into an VARRAY.
424: PROCEDURE explain_mview ( mv IN VARCHAR2,
425: msg_array IN OUT SYS.ExplainMVArrayType);
426:
427: -- ------------------------------------------------------------------------
428: -- This procedure explains the various capabilities of a potential
429: -- materialized view or an existing materialized view and the reasons

Line 437: msg_array IN OUT SYS.ExplainMVArrayType);

433: -- and the schema in which the materialized view was created ([schema.]mvname)
434: -- It accepts a CLOB instead of VARCHAR, so users can specify SQL string up to
435: -- 4G. The output is placed into an VARRAY.
436: PROCEDURE explain_mview ( mv IN CLOB,
437: msg_array IN OUT SYS.ExplainMVArrayType);
438:
439: -- ------------------------------------------------------------------------
440: -- End of user interface for EXPLAIN_MVIEW PROCEDURES
441: -- ------------------------------------------------------------------------