select '1','0',
o.obj_num, value(o),
nvl((select j.longdbcs from sys.javasnm$ j where j.short = o.name),
o.name),
sys.dbms_metadata.get_java_metadata (o.name,
o.owner_name, o.type_num)
from sys.ku$_schemaobj_view o
where o.type_num = 29 and
(SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0)
OR EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
SELECT '1'
, '0'
,
O.OBJ_NUM
, VALUE(O)
,
NVL((SELECT J.LONGDBCS
FROM SYS.JAVASNM$ J
WHERE J.SHORT = O.NAME)
,
O.NAME)
,
SYS.DBMS_METADATA.GET_JAVA_METADATA (O.NAME
,
O.OWNER_NAME
, O.TYPE_NUM)
FROM SYS.KU$_SCHEMAOBJ_VIEW O
WHERE O.TYPE_NUM = 29 AND
(SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0)
OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|