create or replace type sdoridtable AS TABLE of VARCHAR2(24);
/
grant execute on sdoridtable to public;
create or replace public synonym sdoridtable for mdsys.sdoridtable;
create or replace function sdo_simple_filter wrapped 
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
8
427 243
jBIyTX2EmJkzS97Lq9RAnrQ9dUEwg5AJLiCsZy/NDeQYvvs+DRbtoBG2iZR492OTp2A0L7Z/
bMx8qbWd2ZxM06sFSOYVRzQQgiAzYh3CcLTvaYoDTVrcwQt2pPELiMEY1nofzwVt5SzbEU03
9XIo48aVFIOmvWitUatTPIva8Y+WsGaeEqLutfRhAFHRCWwYVGe9z1T1LcJ9Nn7bL0MfS3Kl
4Uty2vP9mKm9hMtR6CGAyxt6bZwOIZmvIhe6ZFylFndYzA1m0IN1VHQ6sUWefgJaACMFXIej
9iz6G3Ko4MfyA/b+e9bVt2oVv9IhPDJViTDtzUxqGd0vVEz9zHtRbzPMXYPzKHrlheJi9spO
u1J+WUEPIRGcSSzCDMuTy7BW0GvkaGNpFzP6PtxtFAyZtAjm7I1pcf/BVpaG7djseIsfsBP/
Zx/UHkYuOaUdEl7UxbHq+LCjedqByqVrUSs4gzC7OSMls0DEqQCDpb+7sSkmlf/lwS0w6d5W
VK2vCzu67M95YH+W9Tref2CwcNUWBDxw0iF+6TOolFEoROmkyLMOFQgYQv5E3ZDOzA==

/
show errors;
grant execute on sdo_simple_filter to public;
CREATE OR REPLACE 
  FUNCTION qry2opt wrapped 
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
8
e28 5e8
/wTuxmZnXr+G8N/L6DgCbbk84BQwg+3qzCAF3y8ZA6pEDzkM4x6tuYffxB0RCHa2yFpYGoPO
oYUrHZlpFDuGa82dmqTpoaALxst8R3zg9DTaGRD+VaQDTcOLGiuKHjPG0gjZ0frFaoqDPDlv
zhENiH/GwQ3Xp2m4MzcTfvrX9ds5ijEHXY6WyvHx8nEa8sBb5Vj/KJxKFvybaREBPHgOmckC
4in7bpPQShGnaKUVnxhZ3azqvgvll0532f24jcyRhVo3r0OPnEJDpwl8osapwDIBr86BCafI
DETgUOxyx4X2aRr603G4JYQuL3KxXwoylzklUVNf5OwMlddFp5evsnWIucmX7UsMUPd5g3nW
oRncXoMDWJh5Kpk33qS2xU37xCrhA3dRvEFaIAL+HMhub1jSwAliIb19m75n3meg+NU6z6pc
N5PE4Q4ierYODZqaxmT6kdvsZHIdPmbOM2nzscDeVV8WN6JrgjMzauzG3VLqRB3lxYuyJ+bV
V0o+rSFYlVneXwRbBhpXGFcW4R8om2eSCb8SBxPHU/cn3QZaZloVCea74Ie07LpdE/26k4mt
d589jqElsREjX4p+JK3BVrNq9s3YxUHZAjazEycMzm4mOHEKavP9I+LLchHzNaPCUB/6JS+t
rGSMpZOm+NyBUcScda39mzXA9PqhMNz9Bp0aVRHFHtS+/1fmUGnSdxcokEEa+xpXb2kK8toR
4b1GgZS0LZyJ5b4yGyl08AQzaHZ38LozbSkT3sccn/AW/XmdWoM2TwcDMu/dm+YOAFb1dGib
R5RoAdkKc7ImwjTTj5mS/An2kPHRE1NLBelSMhDRWKA/YVXVIbyCLstjwDvZNZyXRA7BP2lw
E7NM0E86LpGgCyycj0n6cvKYAuKJpSvjtQuukj9odvrSfzzx5qVXV6gfPyeziYmn7q3wmEfu
s/u+UHEI4+uGY5aiKCPmhL0gOXry6NFSSAxWzxfFBDOdOKfQFUsc86e0gv3phWLkckhGhmo6
8sqiLvKDOqkcccT0Z9KsD7v5486RClYd9v5wVjYEgt9xo02ZzIZt38MUXR3eIs+Dz8SYmM1I
VyPHc5+SHiD362pktX5hJLSfTnkSnQVL15/4UwH+KF3Sw5xIdf8zNIGWP5IN1m2onBRVaeTF
0eioZ1EU/XRFqARz0qm2XwCgQcT69WU1SOtoSKj9oBhkNUNlcW8TVQ+qLK9D4JHLS965ugSI
OiT/S6BxxO+ErBPEphPP/kHDJTMRD/qQ/Y58k/KRI8IYgwXvgpIL1WitxIDSV0Kx99s/pq/M
QjKkgFo/1wYh1G1zx8eUvUIn0QAwKxixXK/Ps27nho5swnG6WjMRpQ+c1D6eNMIhM7h+0bWC
cqp04fL8Y0wGLf7FTJm5MM0Tu0OgAc7B5+rQVRhBvGjNubsigiyGiymcVVVPT3iuiuvvEjBo
Ldf++LBVfFH0JJYjefkSWJUi9vXrtBAXriay51+pd4qwqvvgXQBm

/
show errors;
grant execute on qry2opt to public;
Create or Replace
  Function SDO_PQRY wrapped 
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
8
f16 66e
9Yf1NpsVJifqlOuigYJtM4YpVYowgw0fTNCDYEtkxmR1IsN1PKh2nCEn+ullM6thLb9VgUVb
EC0Ra5ehv7h74/Hk+P/i7Rkqdadh5WwUepqagkqZb/KXiF3zlgNPldN6iFnZem63IakP4fP/
HX8zNfuTyNOZ/DWxhJP1l9ipnHwHeq1RHUFM4itQ51T33PRnjUKt73pm8UB8Y1Yv2fFlocnj
HkxM3hz1b6EJzb6ShBpUQfNPRGZaTtTn41p2jvSieaFlpl3zom+sNatD2c/j4bOOX1TmL5SO
wEpAAgIvRvrChfRnEWCC8WlgZqCOoAme6up5DEmrHGW9UPTMrTUt4+k7Y8p/vF1oS6hRmdHr
R1cZmzQVZsWQxdS2X3HJNlA707eJiZKyYrHc4dAuETQICjfyOZPd9b1MYIzjHtMx/LUraKI1
5Vr1ww6/gqtZViuxNvU42p6l5xJBsY66Sd9j2HGJ5YQO4mWZD0E3tYNEKG9VwC+8eh278Wpm
7OyS9e7LtDwL9FBlL2ZU3MNfsJFgk2TqW2jw/tDEyB/rcZ4XdM6p8HUv37fHW3swf+Jmhhsa
1+KpxkeeyZOQfpMrmfVYYqDXP1ExptBYBeyQcbo8q33APA4YLfRUdEHBKoRb/WvsNvtt3QoF
DAftNU4jVHSpmYILShQE8Z3IUWx0Z/+9Hj29G+Z06WfHCejM9JZxMHMh/PhQxpptHhMICizP
fKv4T7nEHlVJUOGxmNccYZgdeuLLnaqpBz2c1wPU0gov8yHW1IDctV5tTPGDntWGzdpXySdC
wUfFje8UvU5rjvvZC9EJjFAg6LVnH3jIFElM4fydt4MssSRVWVrTSXYdETGgTIIqQYeH0GCB
Fk3eeccCbjiBjmugeYs+9CJfQIyGwYHMpN49u4+LmrANtca5hoKKQe5S/jQ3agc9byGRELVT
Mbm7vwUA2C9rCe21ztKgEiJ+PDJK14snbGh0BoPmv40/EJmMp5AbNngDkVSW8E3blAbe/nnK
ENokea1BEOyIKQUI/AW9QvQ2ghAQ2mcewkjljHkAk1oNT0JxmymuFIm119YMNFNZWgfvVOpV
YuU/eu9ZIKqK94P/bhR9LzaD6u2QDDQRFD0HD+nTmYr3puotbK9DLKI3dMpNWrmLosinLz/G
46kFPATqjN0yR2OxHf48iAXG20EuodzrVqgBWbahRuqh824MXHE7w1fMuZCiuaDAe5kd8PwL
HbciIX/aMQ7XVw50rleTG8/J2Iy51FGftaDNKXS1tcEY3qW5sLHFH8ehQYlHxFw4fYJk3MvF
iE5ZI1q7mLDWICg32cWY7bW6N4Is4R/f7ANyEBGDDXuDW4FTla9BPWPckVcgcUFv+hJjrpht
nMXEHyfmXsXuyeSL+HiNX/wExrMgWkColnUhWuVpsbbrYo6WC9C87VxZ1p4R8FAspsrOkBeR
QvVwXujps7tffD3BGLE00VDRfsYbUpqPQfCziRElx6e6avMbeklAPDd9xEEDNiHBZhRYxdeD
bzsH7kT0jA538m5EpXiYnntIyLmwnaqjpLnqKGfEHtfB1/lDOIEFHRlJHpAZuhNy/vjWuiWj
T06jEKoucROt7D6bYS3BtCPFh4u2MJs9Tzq541I=

/
show errors;
grant execute on SDO_PQRY to public;
create or replace public synonym  SDO_PQRY for MDSYS.SDO_PQRY;