[Home] [Help]
3754: CURSOR c_indexes (pc_table_name IN VARCHAR2,
3755: pc_pv_schema_owner IN VARCHAR2)
3756: IS
3757: -- -------------------------------------------------------------------------
3758: -- The use of dbms_metadata requires invoker rights because roles are not
3759: -- enabled during the execution of a definer rights procedure.
3760: -- For this reason, we added "AUTHID CURRENT_USER" to the package
3761: -- (pvxvcons.pls). If this package is not made invoker rights enabled,
3762: -- Oracle will produce the following error when dbms_metadata.get_ddl
3758: -- The use of dbms_metadata requires invoker rights because roles are not
3759: -- enabled during the execution of a definer rights procedure.
3760: -- For this reason, we added "AUTHID CURRENT_USER" to the package
3761: -- (pvxvcons.pls). If this package is not made invoker rights enabled,
3762: -- Oracle will produce the following error when dbms_metadata.get_ddl
3763: -- is trying to extract DDL out of a non-APPS schema.
3764: --
3765: -- e.g.
3766: -- ORA-31603: object "PV_SEARCH_ATTR_VALUES_U1" of type INDEX not found
3766: -- ORA-31603: object "PV_SEARCH_ATTR_VALUES_U1" of type INDEX not found
3767: -- in schema "PV"
3768: -- -------------------------------------------------------------------------
3769: SELECT index_name,
3770: dbms_metadata.get_ddl('INDEX', index_name, owner) ind_def
3771: FROM dba_indexes
3772: WHERE table_name = pc_table_name AND
3773: table_owner = pc_pv_schema_owner AND
3774: owner = pc_pv_schema_owner