VIEW: SYS.KU$_EXP_PKG_BODY_VIEW

Source

View Text - Preformatted

select '1','1',
       (select o1.obj# from sys.ku$_edition_obj_view o1 where o1.type#=9
               and o1.name=o2.name and o1.owner#=o2.owner#
               and o1.linkname is NULL),
       o2.obj#,o2.type#,
       (select value(o) from sys.ku$_edition_schemaobj_view o where o.obj_num=o2.obj#),
       sys.dbms_metadata_util.get_source_lines(o2.name,o2.obj#,o2.type#),
       (select value(c) from sys.ku$_switch_compiler_view c
                 where c.obj_num = o2.obj#)
  from sys.ku$_edition_obj_view o2
  where o2.type#=11
         AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o2.owner#, 0) OR
              EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '1'
, (SELECT O1.OBJ#
FROM SYS.KU$_EDITION_OBJ_VIEW O1
WHERE O1.TYPE#=9
AND O1.NAME=O2.NAME
AND O1.OWNER#=O2.OWNER#
AND O1.LINKNAME IS NULL)
, O2.OBJ#
, O2.TYPE#
, (SELECT VALUE(O)
FROM SYS.KU$_EDITION_SCHEMAOBJ_VIEW O
WHERE O.OBJ_NUM=O2.OBJ#)
, SYS.DBMS_METADATA_UTIL.GET_SOURCE_LINES(O2.NAME
, O2.OBJ#
, O2.TYPE#)
, (SELECT VALUE(C)
FROM SYS.KU$_SWITCH_COMPILER_VIEW C
WHERE C.OBJ_NUM = O2.OBJ#)
FROM SYS.KU$_EDITION_OBJ_VIEW O2
WHERE O2.TYPE#=11
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O2.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))