[Home] [Help]
3732: CURSOR c_indexes (pc_table_name IN VARCHAR2,
3733: pc_pv_schema_owner IN VARCHAR2)
3734: IS
3735: -- -------------------------------------------------------------------------
3736: -- The use of dbms_metadata requires invoker rights because roles are not
3737: -- enabled during the execution of a definer rights procedure.
3738: -- For this reason, we added "AUTHID CURRENT_USER" to the package
3739: -- (pvxvcons.pls). If this package is not made invoker rights enabled,
3740: -- Oracle will produce the following error when dbms_metadata.get_ddl
3736: -- The use of dbms_metadata requires invoker rights because roles are not
3737: -- enabled during the execution of a definer rights procedure.
3738: -- For this reason, we added "AUTHID CURRENT_USER" to the package
3739: -- (pvxvcons.pls). If this package is not made invoker rights enabled,
3740: -- Oracle will produce the following error when dbms_metadata.get_ddl
3741: -- is trying to extract DDL out of a non-APPS schema.
3742: --
3743: -- e.g.
3744: -- ORA-31603: object "PV_SEARCH_ATTR_VALUES_U1" of type INDEX not found
3744: -- ORA-31603: object "PV_SEARCH_ATTR_VALUES_U1" of type INDEX not found
3745: -- in schema "PV"
3746: -- -------------------------------------------------------------------------
3747: SELECT index_name,
3748: dbms_metadata.get_ddl('INDEX', index_name, owner) ind_def
3749: FROM dba_indexes
3750: WHERE table_name = pc_table_name AND
3751: table_owner = pc_pv_schema_owner AND
3752: owner = pc_pv_schema_owner