VIEW: SYS.USER_SQLJ_TYPE_METHODS

Source

View Text - Preformatted

select o.name, m.name, m.externVarName, m.method#,
       decode(bitand(m.properties, 512), 512, 'MAP',
              decode(bitand(m.properties, 2048), 2048, 'ORDER', 'PUBLIC')),
       m.parameters#, m.results,
       decode(bitand(m.properties, 8), 8, 'NO', 'YES'),
       decode(bitand(m.properties, 65536), 65536, 'NO', 'YES'),
       decode(bitand(m.properties, 131072), 131072, 'YES', 'NO'),
       decode(bitand(nvl(m.xflags,0), 1), 1, 'YES', 'NO')
from sys."_CURRENT_EDITION_OBJ" o, sys.type$ t, sys.method$ m
where o.owner# = userenv('SCHEMAID')
  and o.oid$ = m.toid
  and o.subname IS NULL -- get the latest version only
  and o.type# <> 10 -- must not be invalid
  and bitand(t.properties, 2048) = 0 -- not system-generated
  and t.toid = m.toid
  and t.version# = m.version#
  and t.externtype < 5

View Text - HTML Formatted

SELECT O.NAME
, M.NAME
, M.EXTERNVARNAME
, M.METHOD#
, DECODE(BITAND(M.PROPERTIES
, 512)
, 512
, 'MAP'
, DECODE(BITAND(M.PROPERTIES
, 2048)
, 2048
, 'ORDER'
, 'PUBLIC'))
, M.PARAMETERS#
, M.RESULTS
, DECODE(BITAND(M.PROPERTIES
, 8)
, 8
, 'NO'
, 'YES')
, DECODE(BITAND(M.PROPERTIES
, 65536)
, 65536
, 'NO'
, 'YES')
, DECODE(BITAND(M.PROPERTIES
, 131072)
, 131072
, 'YES'
, 'NO')
, DECODE(BITAND(NVL(M.XFLAGS
, 0)
, 1)
, 1
, 'YES'
, 'NO') FROM SYS."_CURRENT_EDITION_OBJ" O
, SYS.TYPE$ T
, SYS.METHOD$ M WHERE O.OWNER# = USERENV('SCHEMAID')
AND O.OID$ = M.TOID
AND O.SUBNAME IS NULL -- GET THE LATEST VERSION ONLY
AND O.TYPE# <> 10 -- MUST NOT BE INVALID
AND BITAND(T.PROPERTIES
, 2048) = 0 -- NOT SYSTEM-GENERATED
AND T.TOID = M.TOID
AND T.VERSION# = M.VERSION#
AND T.EXTERNTYPE < 5