CREATE OR REPLACE PACKAGE BODY dbms_defer_query_utl wrapped 
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
b
5c93 10e3
fKKbuq6Q3psH+IXVMo5058IqsAYwg0NxtSAFU5SaZNcPNXae27k6X8+I39iTOVqOkBH3PpBa
xjKq8yVsmIHR9sTfVTtntc73iRb3Zj7MwhBiNA5EfvS7CBAiz89mOkFuRKUbU+bKWYyyU6pO
ctCVc2qaLCKOtfnSpe7HCCkp8zZdfeembgZmsBN0lK2sUm/vWW39oPuBLFl/a/vopmSnqJev
2Qy4wK9sTLXCegIWo0PnaGg0nnDIrvEhVuJSiecQfzmomHza4ackGWWhqE261FeFeOlfPkXm
vkwbhWSehYr9Zh0dMPCeQG3i42Rf/9CoIe0vCZMccWId3ZaLbaZmfDeCodvSFegfuGUf1XTe
buCz0sUOtkqesPLVA2rvSLZMQ839AEB8zflAVjMnhRWaL1PqhA7EqFelfNv8Z3FfrqA34MhW
Jc+tU3haL/DvrmGXJlXG08s0k0UAoqdI1naHWzqTLK7E+XqvhF30t3fG89LBFnuiSlGpUSJK
ZqpKm4H7wIlbHiIYmw0k6bOoCYnihk2cGoUkHGwHBNC05cJ4HGwZdgIHhcx9r8x9cvO8ANtc
8bvhppqStkQo9xZPlKYcS4vcy/EU0D4HmOhuvLNKEWbfg+Hi3pZLu9ZsaZoQA6J9MSLDWI+Y
PweI8oJ9SEA461lQwbTHDJIEbMuSVuSvter5cYo1eBKnoZ69MortuqxVBxRG3JZHpmecWwSm
ETSiRNb6crGbytRNv6iAnBmot/EdAV9QcFiyGvDO62AP0EN5VlILWP3uftKBZwZ9HvvLxEQy
jL79LhlUxv1ZqFJSEQkEIKcHKc8TY3CL31pA98bnCDOdV2YHoYeiYPEfOgft9eQ/zf0UctGA
Xi6eqfXpOvO37YEyZ+I4q2ufHjjGXimpkMps+t/z9c/npCyExjmzkTCOLnY4w4bz7eCSymJd
Iu2hep8bpPBdjHj5K+HADnFFVHz55UNThd31xLsMZ2FOjsobAWDfoup/IuXqmgGbt5Pto2UB
GsneG4h1oVqCuHvrmDufcVyu6k2oE9Vuicii70bvC2fRStKQZwDARpOgdJ52VrMaCwTds7lA
Ds39y5KruQbpzaicj3RQ9kZjAI0a67VZyZ0kwWify8SCeA/w+/LnJfjGChQmuX+bhgJ2OQJV
PIueeZ7sb8X4QLehcs8zipMxiBUkb9fY0P0Vid9GUdj0Cw1vW8atZgpGPB9JwUnhUWDtSLFs
V/Mdae5JFjXI5VdCjqHVlSrZbXpM4cI41GLB86N6lnDIFPOZ8qZgMoyBKpeTLwKzcaxToKUU
IMXvBHzovnVdxsUrVX5tQynsf9ui3BMtRGK4h0vAia+pIhfLtwFC7DfYAtUTxPSgBCYq3lgn
VKMSo05wjou9rgv+DzWJvRe6Tr3W62aeEWlWJZS2w0BL8QA/CKwN7iktpol5hzRXpz9+7MUd
GIs9k5OSJf0uSp+IUJ0/V634OxX0l2QqQREdUCxpNGaX6p4+xYnt244N1qg16bf9LFwlc2CU
15cgethTVUUiFhwsCdTi0wfYcBI8BzTA0K4pJvLlIvap5A8uT5tkQaKwFxcBS+MlFL2bZgy9
JIzf8jt7yZNZRrL8L+nu8Y5Hs56Jwd4iF9rhrBglCJcMtyz//3KutSEdxuzihia5xXPMXHDg
VnR02MEQNw3XELbMKsfcv3D/JsbCs3lKgKmxOZyIH04ugxohp/Ddx/p7hOghfkRyPF95/t2R
+sXDgd/lvCSQrFT8+7bfXYjHYqzAI1Z2ytUriJZB95pmb8bOxOy3CyIuiWBptRg9u149EZV5
E1lETYoBCGvPGVmjpwP7fz6S7vV7lOJBCWpVXKyjRVnpX7IBchpfDm3JUIuDX40+ghtJY5aD
Knw6GRZxYkSghTBrFz1x+Ef5ZY95lzfEPpkZ6Hq0EpxI4h1jJqo8F/eAcORzKfox9MJMJOIi
kwsLmHYFYZrq9wVh+UgPxZBGBRaQjCr5koJcbqSFgtUeLZxxj6Te8wx3DsQWViDc0iUp3hCe
azNdfKwsqc0l4wLr5xm3auObIXmcyWewiAEPRajkhybDbkOK/0pFySMrkiG6SYzP0QdG/t6Q
CTthbq3oHe+EDL1gaOv33xFZGoO+jZYrscnc6bqxIro1kIMoLXacrqnNwssJROCIUMxXLShQ
e95wLDzJtsHaYTQ6qa/NOf8gshVHREWPFUiWb9T45vCck9NqdZKMjbhW73oEPrnWo+pjzab8
UMwyHUMMYTVXvmcfR00Sor7OQeG3RuCsR9aByl/YEB/bRXxoy7ONtYMcOAJq4cicVijWhWx7
NWBVyr7kvHDyIaem2+rq1uEvtn10Z6H+2PVisL+OqcVXYaYhjj651hi/5zK4psDhsgcGdBJw
QFV8ajV8Wzp5fTY+xQJAqSEetEXKsWPPn4VxMUHKDHCfhQHJIxZIDCqjSTAlmYcRaO8dKtyZ
stKBpTcgsJva7rFEy8vk0g0QIO0dfWzfmRFl4Q3tb9gSXfhLth/OTA5JSM76EeT6fOHxhznx
7QnIU1fjeNk1dFOXMUWPeA0Qn6WK+bxxnawXr6T3ONneZeG/d6SbtHPt7tHuWFMdNPP6ZtWf
+4cbWS7LhUBH1TrT3yOVFq81Zqv0kYO/neSbmphPubmdtpzxV0fWz4xUTORT5jroVLMacHjp
jDJZZDooYmnoO1YCnsDoGN4bt/zCr/HeraY+X6QCosDn6kLKMHBiQxeABdOf048KlLWkvRGb
dUCq6cgswhShUtkiY2qfaztoUSY7l6EN1f60/+DAkgf8qQNcsEm5cy1FsOXluZCQbm7DvwL4
Y/ZfwAD6MuIqL+8neVDOmINy2dmf6QEgotVza1jTG/PadBjLXG4Gky7J6ansKPcp4P+xWWtg
kUr9xY26YGZCHAI3Z1qO/ZfkUiZnGsS+bOzwPIpLegIi5Q31XakTt/W5IHgUo8H1UYcGKXjD
VgaisMG0MwM+Tk8cQRj+ID8/zgVeCLnrhgsILDMpcwcGuWqulq+Y/o8pTp0c3WQgT/n7Sq+c
luxFsP4gu5Vc+wmhinewi/L8lb/xWdhdEhrneT3igj2cDXAnTx47RiiWEoXrLq9W/wkcgZ5h
2VCH5cVOfkHpEEr+2H57NMMhZIfww2u88JUeN1Ke637rgeCn+Cpi6RySlwq7ID6bQwpxSpJm
r+RjxxLeXRO0DTpmgE0caqERGgPa9RjwABPCgNS0TJ9BhDC0+/7egEIUgyA2QF6CKqPXtgr4
DyFclPLJIYDkprjBTpH43sJzVr0FKjMZTh2r8byCHWphXf/Boq2Rl9hws98P+hdiIDUvqIr3
0j3JDAXmzipWfovzfQMo/qsR3H8F275L5JsE0G006Nl/aka/IE4Eq6OOUD9M4IkwTTtNByQy
RrSlBy6+P/6njNnYbungZkCE23Bi303EmyGTei9D2JbpOn2cYeNPxGnRnr20RVT8r5dDNiad
8GwGWoGe6eqmT1w/ZQo5zzwEZfZFuwQI1OzeAYWp3WyThmGdNH6Lb7qVLQzq0kU/DpkNthm5
lo+RJ5N/bZPZySWiLU9zC9MNOe13TRwSPFJiXjXO1+FR/Vd2WzT1YFT7W9xdaenL/l9odKBI
aDAUpSclC7R4i1TW4v8O5XmknXlSOuF1voINptmSA+EzhEk67+GjBvKzbEGU1K0E0dC4GBYb
NXUOEcJarNUcM86ZqjL+3uwOprqH5fEX1W5nYcy6s1etEwd/lCdHIy4FoVBuZKSIIkher5UY
U2FgJHcnBcXzKnIiBkA2o1tMkGRnYbrEIZeU4JXZoBvo7QZlbAUKHwIhCfHfGO87Z8I7BEiw
VKpP5fbKIbEGPZuVe8pEFZpfFz6LEeI9YT25k5+ihqQMzGMs3TOSjcUxu8yABfddhroFvzgw
WPZZJ0mG/hrVGxPJRdXtWJY9MG7nr6kVHlzoSib5M8cF3mILFN7gRTYdHnqL9hs/tN+t+YG5
CwgzVetqB7+/0NBPbfjELLsZeiJoncPc18N0D7yphlhX2renCNXHk8GXHPQ0VI0TrSZKxYy+
pVmGc3Zc9pFrUXr3X4vMddvOQAAQpI4KHSeqf0EsvUdjvpymmhu2nOLljbUtTGx8kMIy6ewq
KL8KHjEswF+WNcz2pMrrz34XyRKPTnI0DM2JwPMULjFkHYwAbiE8oBn/HxzBVmgmdhrTb0Te
m8HQcQ3ePTj12qP6VFZztPdyOlO79Uo3Dy78L+zGzpfIf6WxqtZEl41RqHA5v5Xlxcqg8aIG
FEcV/5W7+VsNHz2d

/
CREATE OR REPLACE PACKAGE BODY dbms_defer_enq_utl wrapped 
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
b
1675 5c4
P6m2usolZ3e36xQ8TGWvJ7W3p78wg811mtCGIS/GQrkP81Ve1VzVNy8ow/6PDy47Mm5BzYqH
M5Xhn/cvuNPGCLWCn/E8Js3kTY/79CdcDfDBgoZY+tuaAO+b4/Irj+xhlR7QnbXeD5o/P/h+
miJzOLWSm7o30ugWueT9Iq8Fkz1Gs2AtBszTM6JQbybCj8Iw5hhuyJLouLvjBOie11k3kfb0
GaTdd4iMwuZLq+Ic8ziVp4pb/7lpGocThbB+3bBOFhOegioHQENts3fSERh0Ex1qBpVwgWjW
lCNBhhWDQ3F7uB4X3Bf69a1Y40FZovC75T4vbxJq1nh0GYvdMNPPfhR/NKc/3qHKKkchJ32n
iCHYDxgrVLIRcbGsqEK0210M/C2Xqbc6Fv3LOk39Axo4cAibwkFF/W+H4mFpPPgnEqOHul6B
DSo04G8JVAx5jgbx199WddG/jB14gw78NCWch+7ZNDa6ZZbVAFiclJieTDIFo82uwXbU+TC6
MrmDl9ZByFTBdKZteMYmucY7vOuIPdVlPgbDGIG+jliRSgBlOms4p8qo2AdaFGG5E95yiieG
ORycWg0/zPp3P7eI8+xuVAIU5VRw2nrAAyvBuVkvdWItrDpwoVVattQ+8197FMJgGPM/i1mr
+IWDjROMioWJ4Hfm8xpD9ZN1wujI7sqXlByQOxxzBkUv6oOSVBx6urh52DGUaJButMbiGEF9
tpK5sa4k7a8p/JC1objY3cemLVAdYX/hV7SWQouLw2dkiHAyTDnWxODdPQX5wRaPTRch+d+j
jiqALsr1lQGIYvB7BkUhQlgMl71lKnp2uHEYTV5x9ZXJ4ioJEuMjcHZU9UJ7S014CdGMG6ac
Gm/gsZSO+sJSWyfABJqDGK/Hm6vGosfP+ZvZHiQxpII3TBf/qsl3U4+ErrUoTZhbjslsnBx4
gYoxW0NVB+n9Zr5dnyT/tCLyFfnCr7nruBFdxh53I099zlssWJh+N1t4S61/MRKu2BwlfqjC
zSrOGTE0oUvGGUChU3nQVcGTHrw17T4EGWjAjA1tRqV5LeGUkAjufKgkqhGuLfgdqkBV9FHI
GW38jpeZu1aXoYsvXWz1nobpn28dI0kaVzq3rDA1pObk8342wBgwRpvTrb2MtzpboXuXqisv
SU6W6LTOQM1DIJ7WSX+PLCXw5vFIgYS1TtK9iwexqoGmhqzcAGHRo0VGByZnfIXkVMiBVGSa
i1GYU+0RgfUoLSiy6lDwK6+GdmqmfXygJuXfwx7qSL8p+P7WVLuvvY7ORbKdRuU39e7146RF
b3qfW6hDvHmd+Ui/4xj8w/mltQqvwLh6BhmKcgr/Djy9OJD8qJbbAwD1lOl4XYmn3AaBFByJ
PHmF987y4JAn2QsyR9dNXfVHt/UvA6h6CvReEWQaTpHlgGoJZKjaMXr38/cM9FR1tvNslTKR
egTLD3Oytzy2uA==

/
CREATE OR REPLACE VIEW defcall AS
SELECT step_no callno,
       enq_tid deferred_tran_id,
       substrb(sys.dbms_defer_query_utl.key_to_schema_name(
		   recipient_key,
		   enq_tid,
		   step_no), 1, 30) schemaname,
       substrb(sys.dbms_defer_query_utl.key_to_package_name(
		   recipient_key,
		   enq_tid,
		   step_no), 1, 30) packagename,
       substrb(sys.dbms_defer_query_utl.procedure_name(
		   1, --dbms_defer_query_utl.loc_normal_call,
                   chain_no,
                   user_data,
                   recipient_key), 1, 30) procname,
       chain_no argcount
  FROM system.def$_aqcall 
    WHERE substrb(sys.dbms_defer_query_utl.key_to_schema_name(
		   recipient_key,
		   enq_tid,
		   step_no), 1, 30) != '** NO DATA FOUND **'
       AND substrb(sys.dbms_defer_query_utl.key_to_package_name(
		   recipient_key,
		   enq_tid,
		   step_no), 1, 30) != '** NO DATA FOUND **'
UNION ALL
SELECT step_no callno,
       enq_tid deferred_tran_id,
       substrb(sys.dbms_defer_query_utl.schema_name(
                  2, --dbms_defer_query_utl.loc_error_call,
                  chain_no,
                  user_data), 1, 30) schemaname,
       substrb(sys.dbms_defer_query_utl.package_name(
                  2, --dbms_defer_query_utl.loc_error_call,
                  chain_no,
                  user_data), 1, 30) packagename,
       substrb(sys.dbms_defer_query_utl.procedure_name(
                  2, --dbms_defer_query_utl.loc_error_call,
                  chain_no,
                  user_data,
                  0), 1, 30) procname,
       chain_no argcount
  FROM system.def$_aqerror
/
grant select on defcall to select_catalog_role
/
comment on table DEFCALL is
'Information about all deferred remote procedure calls'
/
comment on column DEFCALL.callno is
'Unique ID, orders calls within a transaction'
/
comment on column DEFCALL.DEFERRED_TRAN_ID is
'The unique ID of the associated transaction'
/
comment on column DEFCALL.SCHEMANAME is
'The schema name of the deferred call'
/
comment on column DEFCALL.PACKAGENAME is
'The package name of the deferred call'
/
comment on column DEFCALL.PROCNAME is
'The procedure name of the deferred call'
/
comment on column DEFCALL.ARGCOUNT is
'The number of arguments to the deferred procedure call'
/
CREATE OR REPLACE PUBLIC SYNONYM defcall FOR defcall
/