VIEW: SYS.KU$_METHOD_VIEW

Source

View Text - Preformatted

select
  m.toid,
  m.version#,
  m.method#,
  m.name,
  m.properties,
  m.parameters#,
  m.results,
  m.xflags,
  m.spare1,
  m.spare2,
  m.spare3,
  m.externVarName,
  cast(multiset(select * from  ku$_argument_view a
                where m.name = a.procedure_val and
                      a.obj_num = o.obj#
               ) as ku$_argument_list_t
      ),
  (select value(pi) from ku$_procinfo_view pi
   where pi.obj_num = o.obj# and
         pi.procedure_num = m.method#),
  (select value(pj) from ku$_procjava_view pj
   where pj.obj_num=o.obj# and
         pj.procedure_num = m.method#),
  (select value(pq) from ku$_procplsql_view pq
   where pq.obj_num=o.obj# and
         pq.procedure_num = m.method#),
  (select value(pc) from ku$_procc_view pc
   where pc.obj_num=o.obj# and
         pc.procedure_num = m.method#),
  o.obj#
from  sys.obj$ o, sys.method$ m
where m.toid = o.oid$

View Text - HTML Formatted

SELECT M.TOID
, M.VERSION#
, M.METHOD#
, M.NAME
, M.PROPERTIES
, M.PARAMETERS#
, M.RESULTS
, M.XFLAGS
, M.SPARE1
, M.SPARE2
, M.SPARE3
, M.EXTERNVARNAME
, CAST(MULTISET(SELECT *
FROM KU$_ARGUMENT_VIEW A
WHERE M.NAME = A.PROCEDURE_VAL AND A.OBJ_NUM = O.OBJ# ) AS KU$_ARGUMENT_LIST_T )
, (SELECT VALUE(PI)
FROM KU$_PROCINFO_VIEW PI
WHERE PI.OBJ_NUM = O.OBJ# AND PI.PROCEDURE_NUM = M.METHOD#)
, (SELECT VALUE(PJ)
FROM KU$_PROCJAVA_VIEW PJ
WHERE PJ.OBJ_NUM=O.OBJ# AND PJ.PROCEDURE_NUM = M.METHOD#)
, (SELECT VALUE(PQ)
FROM KU$_PROCPLSQL_VIEW PQ
WHERE PQ.OBJ_NUM=O.OBJ# AND PQ.PROCEDURE_NUM = M.METHOD#)
, (SELECT VALUE(PC)
FROM KU$_PROCC_VIEW PC
WHERE PC.OBJ_NUM=O.OBJ# AND PC.PROCEDURE_NUM = M.METHOD#)
, O.OBJ# FROM SYS.OBJ$ O
, SYS.METHOD$ M WHERE M.TOID = O.OID$