declare
begin
  begin
   execute immediate
    'DROP TYPE sdo_numtab';
   execute immediate
    ' DROP TYPE sdo_stattab ';
   execute immediate
    ' DROP TYPE sdo_stat ';
   execute immediate
    ' DROP package sdoCurPkg';
   exception when others then NULL;
  end;
end;
/
CREATE OR REPLACE TYPE sdo_numtab AS TABLE OF NUMBER;
/
show errors;
CREATE OR REPLACE TYPE sdo_stat wrapped 
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
d
3d 69
c/lbb5uA+dlnpUpbm4c/amq5lWwwg5n0dLhcFtz60JbRoVbMuHQrpb+bwDLLzFClxyulmYEy
wLIlzLh0wDJGx+TkDlku9jmmSboviQ==

/
show errors;
CREATE OR REPLACE TYPE sdo_stattab AS TABLE OF sdo_stat;
/
show errors;
CREATE OR REPLACE PACKAGE sdoCurPkg wrapped 
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
9
120 eb
purE+HEygKLMU6mlWUHy115JCskwgzJKfyisfC8CkDqUIEbbldQ7Xt7V0w0hgPYG3AaPcOEI
tRKjZ6H1RZi7QxkShynW5VZAueIs7Z1MzMSIL9EZrCeE4mYKWDeAhDmtbTA+/W6UKe1m9215
LUFLVHDoAm6KYCSkPjrN3fYFL2So8fjb1yxreiPpnZ5L4R+uY2OJip2mGUbQ81YMFHKdbIta
WJMXXfy9lybpjw==

/
show errors;
grant execute on sdoCurPkg to public;
CREATE OR REPLACE PACKAGE sdo_pridx wrapped 
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
9
70c 26c
1Vb7OdGcn4MkxsQ691juDt+Ispwwg5WNLUhofHRA2ppeuHodYKlo7PSnMEovk9MWrVMToJEp
d1FMks5DPimvwM3HSN4Ahcr7CbW1zMId5R+KvT+8ENmaqs8Q+ERX6BeMNfBHXQkc739waM2m
Soxe+jBbAL5HYBdgsV65/4hYuE9RajePlJMA7yyjWgNUo356OIdRNDuCBQBTrrQuo8rqCJ/W
dzF2HeX4Gg+PBBDheMukUpkaEM7n7AnXiWCfLCawXG4TBL9Pn7xsOOWozF+RYhuDA6xN7Uck
NNIoUW1MljWZOahBhtaxlwSwKZFos2Tx844NdalfhDQbxTXCTG/MnKzxyxvIKkrSEhSNPPHX
XUsDNhKhFF7DbXe5dLtooikLmcIc7Ogz333dtqrZIousIFnPyWN+klQHBwGMDF1tOR7Mmls/
kw+SLFDqWE9K23NL4c8bMv6ucMcJn1/0U0Bi6oczvh9hdljPt7+ZMz2HnefZLjSzfwiS4+AV
mSYSQGZIg8oM63fWYhbhEukjkcXvkoQLgdxdci4pIMHCtT2+NHgWiSC1GuCXeWB9YJmw3dAp
ozA61Vy9wRtrdlTARXzLwOPcrg8/HZRJQbk=

/
show errors;
CREATE OR REPLACE  PUBLIC SYNONYM sdo_pridx FOR mdsys.sdo_pridx
/
CREATE OR REPLACE  LIBRARY ordmd_pridx_libs wrapped 
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
16
2c 61
9dpKlCirNvrYoZdGPnsEqvCboUIwg04I9Z7AdBjDhZby+i70lhaXWSbjcvpZxSvnvZ6yy1Iy
zLh0K+fLUnQI9WHJpqZpL7Jz

/
CREATE OR REPLACE PACKAGE BODY sdo_pridx wrapped 
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
b
29fd d26
bYu4NGmCmsxghKuoZQVCc0YqcHEwg82jeSCG39O8ZNdkj5RXVIMR7S2zbwdVi9ZWs0qrkyUJ
w4civUgGLtaSbLhuuW+0LJqI8fEW8sKQVVajduJUdzwRyVduiCLPWklS7ce/5voWM2T6hs17
qrRomj9mSCOi5+T9F/fG1ldmtqtDVqXHi2C27NDix5zMsQbeXdw+vrhYv4vCa4RTCHTRM+Sc
dRuHdiIFvRO4vxqTU9gzNJr7LAJC7FMZTkCVijb5lPTCKeNlB2kk3HfW8Itfm1/p8mbH7Hy/
ZTL0EwhXGLBSp4t2CexFZtm728jkezd8CWAACGJar9Afgk9UaaYVBtndxogJxATlyYsB2GX9
tjBZCxsq0d2uQ1T6Z2vC8cKJrkJYWx7Gt7YqFZMvPV3ydqImGxyJ/GsSsgPRD3Sq5CbjIdfo
xZ+URj6lLvtHz8qw0U+wAcVdxzaabXqdAGxJ8ux8GYk5hrgliZ4XvlqQIrh6kkQljdWBo1oh
9UK4NU5SjrGHXxW02iAN45YF21zrcFdRB8PO0mV46h1dv86E94+0x2o0GR4B7ID106KjpN0y
I5Azc7Mh11UhY1/+3tIiba3XUqYNiZAt/eh3G08kt4edByyAmvQreHnrcOxGIa6aByVx0QsE
vvOT2d3oLWlWftZSvuIOV0ZPs1o7ogAsYoeaF0gEXx386kqNYZcfAiYNmPK0RHI427z1RGwC
nI0NRuGrOi9uuDLDO1tLue1CMlkcyRMx4H8PVAOHs8lRwrAUM+3dbTj30hB7nwPI+PUVFj0X
KzDTT3USEzQjjOTI4eNQ/X3k0oQL37LHgInLsnQXlXblMkoImn6LA81ufhed0YuidfxEoh9v
ip7LWDdBLiselZK5uT8ygCNc+jONVwzTl9jTyXkT5P05K70pKb4WUdNPV2FfHgg4n4ysBXgr
KpdKoeq5F9BdUrx1mn5j/mX0kTya2CQGNFIPNBNknBDkrKFLIxITDX//WeJJO06rMiF59UzA
3cN2woqaGZa76iw83zpLk5Zcf0Smz/lxBVBwI2lQlWaWG5yWwQUxzX7a79mHXjqGIE7Xdmhk
JOKLE+s8ZY640zluZXjD4+DqyuGE4kivB00XvOxiwbDw9zOtVboSf+h2d3XiBPjJ7TCj4uWv
XBH4QD3FzN032MaUgWXLmM318nPdAiBUdMcQDcSx15LeDQ2HMVAPrgz2PJwKCsW6Yj/HNfHh
yYPvqS5YxuD9MtufCmbFN73+6n5U04K+pB1M48J8fh6PGc3Jc1D7y0SiMkM1s4L61tyjpwti
VodGgWKMTX8x4AVeIXf3WSU1faCYUVVePEOKto62pcIr2bu8U+NaMtLu6ROeYSWcbmzj1C0C
o0pg4G57xzE1NzIchneFbYx/b5g1OModPesIZ4YBpejzGlvPjV4eEzlUzIDjZ9Il/VYa1H9s
VQpU1SsIP4FXmn76cyeYIn4S82Lg2RgYxfl/unrXLPSBn4/IxISYv7SbHwDhL1Y8c7wrfy1f
2HjETrI6ga4pYA3MblBaZZJ/2B7l/mpX3IkHf0MZWHfzVQIXrCc6Nm5xQT4stfTgIkoDTREi
LeZEct8rTTCoWoE+iHcPoDJhWs+nObOiSyOARlAXRLfq5HRY2l3czxy3N/lKHpQ/Yp4Knd+r
3eZv0qNXwjIq87jptbKsgJeEW00hHVbsoTSvjFSB8pHn78auYsC0i6guETBxo/dPAaANbo28
CE7OCgdXeYhRdfgOKU6ix2DQvOUYVSpok6/W/P5cYybT6AuYiiBfgY7Mhg2zl1sacKOZNuq3
rWkIpB8a9NMS/sSQcYR5SJ65TaMNzbF4D8d5CxmgNI+NW9sHvDf03YBaoXo83O21PSCtVPVI
J6ucRHFCCjZqRTZ6FnikvxwS0QAJ/9yjgdogAA46JaN1h4lfL0YpGolw1jwUiwDGJCmnUUUB
yF1dqgZZ5NjZ05tjxGxxmI1XpYlQkef8w7/K8NszCss7UYjwEM9bDJZWP286637D+WNOQFh9
uDAAOTQLp6WlYIw8i73dCoYDVOB1ddd+gdqlguD0MYynw2fxtt2KhUuaxmch7F5TFXILdIZM
Qm7I3JUXPW+NXh1B0J8E9L30yfzt781urml6850WTz0JC7eD+gwHlyXC+pIojyOn3DpplTx2
/ieHoIIkI6A9Ke2AWvqj2SbDWdPtgdKX9aDrFplyCKciNoXM7USF/OdXEBeJoH4sNJiLECjO
GoMPzaMe7gwjlag6PA5oi8zFzeZ4Q9+LPcjtHKBBJeUIbU7j7vy1wSbWcl6ApI1QSmMB66op
zJd9Vf+2jWjGXK1V9wH2BRKzIpQ0iaV8Ed3WS0vhmH7wj1S7FHlzE9z1lqQejBpGjzyfly0n
2uoqGGcKMHuVjOpH/yiMx27mImpp9amACSRATqPAIjUbR1G9elcUuOkzUoyyZiyFFvUySS2Z
5Ap7Owxxi9zrCXAeNa+4tO8RytuhyFB8402WT93TDqhH3hRTWEThHONNqHezKveOw3zJzppQ
YTfGpN66RTpe0Mh0HtMoaaILST0gpEFo0q57/+0vNftUHcxYOE6K2TSL+uq+lE/GkfxqPmvl
Z497xTfpGXZ5pgVwVnVibl9EvKtiSdSeho4herbyXDO6+GvzzLrN/ekZCB2wzKqta5KGS+3a
kVwUirBLsum3dKoPM12WozBHzj9C+Esx/yw4lnFHYU67ASas88cxKvRYJIFONuQPQ8q3kFKI
pYJUFGdfZDAxkV6XPgw7Ueabea0+FvI6sie5W0HZlZDn2XqHvPGI9O2mXUsRskLeK4VcK6uS
8hlQH6EKoPakhz627df9vAKgKZMbmJX0z/tIoBBgIJSzLziKknKiSkpI7qosSOeC/izQpDLn
89WBJ1kxkcWp1rvW8JxqbRvgiVKglG4sOW+aHD4iEHUguaeWmbaU8shzfK+6NayqmeMRgOOc
puNIz1AFrFKWRwmFVKSkzhZGvXoT6nAynwaEnDgw86eqw7ZbIllT/QkJueA+QR1mfKTklReO
xS8+94UOZg41J5zKBvqOa+9e2e/opzNb2mMrooP3TbYSoo/z+U0H1rmvT2ZYMnYVAg93BIMP
jYXM50YdDqr1u2eUdlgQSZt2bqm26ZDP6E0CYym5+1a22PVIt0u0jD/UTfNSWwP6KPjWZGC1
XA229GKdvxJQYp/SKcsfUKRS1AyEs4hFppJRI6D+4V3XBilS2prk7XrFu2YJOm3dFBvt21ZM
tFDbZt8hzLRfaz3eJfyUmVVp6TiEXg01C8nyGV+x9r2x9vz60X8qAqApgicIJnk5S1ZSWHMe
lncAhZQ=

/
show errors;
GRANT EXECUTE ON sdo_numtab TO PUBLIC;
GRANT EXECUTE ON sdo_stat TO PUBLIC;
GRANT EXECUTE ON sdo_stattab TO PUBLIC;
GRANT EXECUTE ON sdo_pridx TO PUBLIC;