/************************* INDEXTYPE IMPLEMENTATION **********************/ /*** EXPRESSIONINDEXMETHODS : Indextype implementation ***/ /***************************************************************************/ create or replace type body ExpressionIndexMethods wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd e 5212 12c1 pX4B3YdXNeScJxz/lA2hvp38xYgwg8129iBo35siu2RwrOHxy7pqn/xqKkAoUPJxuuo7GmmJ C6rTaCMFq1oG3VKzjoXQne4MZj78DWELoOrvLerTrXb/EkCMY5xEYAp6vKLOTsaYzbCueMQs 8SixBXITzXNkxLFPUGY+H5lG7Kpsst7TazKN6SH6gonGzMAY3vHMWTw4Rgwkk4DeCQmJ6o6N nEMc/fdk+W3vl0hbph2orN7pZYlcE5QbFj6IXZQiLmX5wzUwEAamjxPEzyji7WPGuRSTX5bL 7cpXPB84rlF61SmHk+mpcPpBBla5UT9+inctMQZuYDYHjrHOUVRJ3pCmtHxtfJu3zmb6PK1W CqWGtEsSDErXXSypw0aRXmb1HPF9VhQHDCEo5lTJ7jkDrpjm3WzozEEnL+FEr8lV5gZ0ioXI RbJu2eUhlM8W8iOrY4M/5Ixzcw6IamubNyGWzlOfj6+8XWxcuicc7XuJ0OA0uRNcUBmTqIp8 BVcs6ZQ+x6xRHV3ruI2d1yFlFbLLwmxtGqb4PlKe0/RXhvYifi6bsp5eGxa4KJx9zYgbBPtZ yiW98Y9qVjy0HXheVuhPTYE24Ig/mUY52Hluuj3zjpN5l2Dm+ocJPME47NsyWj6KRfc9AErD iJDuLlOJ5ra4pFCo3wXTkitJf37Ii7LZE2IYwSdt10B3h6RtwvDVS8Cd1Ba8x/u9D6JTcHsW 7hVmDjGOp8XzAU8f7JK4NHTzNjKc/R5zY7ZiGxIJckSWsioXUJzizdJ9QhcMPJFQAyUk5zNX mjpOlcjc0f0dLcPsDYnsA4lFL1/NPfk91XtxSASknqy+5MiRXMzIC6qS+cYWqH3eu93dl5UO BLddcco5ieu4BQKAaqf1yLz6qzr5xfs64y5RS64eIXoC3juZURRGJAqgVlGmkPXIKYgRBOeQ y5Qu/o8LkH6PJONEgh/9i64DbsAIKBqfhSkDtVSiW7+TnAR8X4TAJiEZqgSQmAl/EOJ8pYIb 5wNkBIWKnkpnEWnCMY9X+6GAh3XmesrYfJu8z944gsb/KfOnbBsv3KY9rwmcIAlI7eTM1DZi 2JYPeqUaaH03YgIB1KltkGHjZFgH5d37F49NaG9M3DXeQR/Xl/Ao+/hauPfmaIYdbu083vDb noyYfm8iSI/SCVhkJwlCiUcbYTUH8TkzC92OrauRk3CF5xtzYKMGWKPxIbzWWOgU4E9GfDq2 5NYGkGrD8guaGKkSCGaW5Xe+NMdrQjNQazsYwF4W4cnAtm8ufNLnBIFrarR12Gwm1GLJtlbS I+a+1sgXLzK383rPmWo2DYqWVJaI8Ut3GoOzKP4jC9D4EmRJP31ysJHmPRMcpIyzdglG5s8z arc+gJ4qUqv///dhVnGrvdVlXitiPfzo8/Ve2DxNu/Pd3g6h91yt6r96OK7gfvBJS2pekWNc hvRyRf7MoXiOiAQs8uN6pMjMRllbUTSXTbVyZ5EdwIB6iFe1G8FreycLMlrnqahL0UO+qcRF vrUzcz3G0AX29WrlsgWuHK45Z/nFpzkwicO0t+CFZla9tZW9e48d+MNFzxNQfXTUYjlxK1ys PlE2hnskSYGeWQkObPMj/IZKrFp1pjYOqtzk6rX5ufjql31Z3AlXY5NChi6XtLQj8lAEuF6s 6PLnHsSo+vGKoORgUFug+XD6NRHRYYxuHshAVr5ITk9KTKA/f3uEOcDycuTizOa1NQeArFm3 48D1tMqxNfAo/GoHOO6XlA9udBou4Ed20ofN40Hi4cqAGvOqUDLRc1KU6JC9HRPTXlhZjCsi YJW6LIpvuFPDIkp+4YT5YFrHoO/ewzrvsCoBAekTZdhaylMBpzVvEDgvsBjMy4jcbvfefHBM SxSpSngX+GQzryhhlWmgvEK/ne22yZ6vKgd4T2fRArcrPU3CIUJWXZP1vRtjyip+oIORrEHF 740Z5gEdGLzAun6rMMl86XRfTJ/A96Ph4I7B9hh1UokGfjRu/O1Gj7pqH+FOnIcsNs4FPA1u n4LZHgRZVO05JLa6i8eiqZ39wm0bBxQSidZEt2j92xZEPJl8b3isb3GqQ5N5K37GM/PTUhsV Smi60HOfsnN2YZAmoSvI5Im98Bd1s0myNVU1fXtZCXYSYPLUjqFliX8ScbXDNw9t1dCwRGt/ +pliNlVs4Xnh+rxXCW1mgGZkTAutk9tAVLYPad2ApSa6RxkEY37ZBC5kkQy07K24XMJ4z2fh GTVVgWYjNeWJlSNAAHYW+GNTXpwQ0p6O7Eys7H+EuDsTkTuVax3IZwh+4EyA0FSkY6csxJ1o z2ckVariZGSazUyaVT/YJBm8mDopKLWBNbhfYSzi0O05+OVGWrZQUPJWcIWZcsJ3VbQ8xWET DYk1xkkLONDVh16/hF7V4E2/wXTCBWrSxovPlTRR6en+j6qQG4gzAIg3jLHYCUngnyu/kqeo J8OY7O2683kDiOG6lj6+aLdgaNWGaJlxbAVBcRqYLg1JuyP4SBKd6SSaVbyAnRCDGT1P4iAe D2HEux7+BfgKHgr41dL4ZAWYYkWdkghVYfm4gT+Zxc6S3V7KNk6VQIrWHyGnd9Lnqe/PHHCq 82AkRrAw8umgzIyIiixV28vkeKUROiSH3/cJ4JfJrorrwbug3QbzkUUk4io8zCRhEwF2bn2R qJ1yZgM8Ax6+OvUX+MrqBb+HepXeEJALt7Ayo/yPGi7+iQbfNIlh/ddX1wQ8aMxzKV4OSGcA 8WV20oFfhaklbzINwfQG0dzaoEXon3o4l3qjRz4grF0t3xOtXNxnbJZNn4RNxttHNTyAYtIH Ktzr1ZzJ3jjY+AjpmtLUSYdfZxGJsXNTzZ9SItERsE9gqmgEjrCh+x0tPgpRUFpVBJPM680i cGtPhTugQadhxeuOp3nAVuzvIi/QJTA/uA7EaE3w83ac0nd2U7sEznakfxHmDFn9HPoCZ8r2 ULpvJPgc1XI3kSPICRU5j+8EOEgB7Q6wJ3hjw3iwhTDSqatNd+u2ecvEZnZJUo+ItJTWYSPZ zdaHoCrghYiVBTh3zV1oOdmzjtg/oMCVwEACw6Fv3Nm9IUxcoasoCP4+5M5qq8qrHlf2Su5H /SbIySufTMu+u5na/idib0c/UUU90rdeY2oVocJ3nn5YFgAhMEFNe7ZmCiFhxds7sgEIslO7 4yM75lk7JboauG+LeSrAYR9Xrmgaun/caNKKn8HvxH+rxSWFEisNady3wzmMJv+JY5T8rQ24 buVzCpRkUoKRq1HRCjkiioOhhtgNS/wYetVLusyLoGNUANGL0QESl2m/13NVICw/RUWcWD+6 Y1efl7nrv/BTjQ3ZmRsACUsxzGQ7jbbDSMXJhhcVTLP87xm3MsR0981CqtXQnm4V27AUMaDM WySu4wh72AmjIxZJi0HG6NLXyJ8HKJQbk4HriDkRm62rxzczrYPvbhoqyBy4iTPIaqDz9hd3 GbwJEHPznm/J2IKqUVxWz3BTjGw7XugKlYEpxf7AxgzYYjtvcz/Qb9Gy2wyX0sUadLFKiuxP i9RG4vSEc2ZfkUrUlFkB1/+Mqpm1Lb82X+RyM5FvKu1v/e7+8hJTWMJUs0HkheWY4RHcVACD Fw7bZqUWZ0EZaCeUnAeZR8kmaHpA3+eKeh818EksaSlrCc6xalTVQ5lEUOh6eJeq8VdqpMrX /r6M0bGeBqT0etozF53TdUzZ3phgV+9knSEgRV+ECYdomNtjH3Rp8UcRu8gbcCYOcn9hee9a thvu9Omcuyic8cxi0HFcb3NOiep2BeHS2+ANijXPffp0oeADWq3eby8s02Cg9sG5oBghUDQa 2xYjRRmM9qr6vUcx6tXOXZmr+pzQ5PRi5G37CWJD/9Zsgw9Ru9DhO5wu4hmt70EJRnqDW7jh qQoqvLW4lafKLYYmACF6GM8b85frzinpEcGMFbVkt+bq9KIeCXX5Bl7EdQb6yUDNwU+dMT/5 ML/4+NcNfhcvEHTKALcaz+aEQfg2kB51huTPGq/SjU6BHCBraim7HLi/U70CE02QXPMHqmXN z2bEpefyVVdbIddP5AKUP1HUlosrhCxqNnq+/b/4pRe/7qpEhhuKjc9sz2g0rx0cvGDS5jQJ ahIUg+YcLKCv0lbQ2YhJyHMA/bZwXemsdvC2NIMiDc3vqoZGCOgVXcDFHMqEmIE/iSGWn+wE SY4gg9mtMwX8eIi9R+Yxn6mWyj363ZPjDEizDwZtMpC4r1eqPrmw+hip+gLu9p5PlS6FuXLI fsovv+yCoAkSqupKEf7dkS6GqB8AyCifyOHyNqJkZkUhvIwVBkXxLTehyuaLPY+PePRCKiF1 vQIyMct4HF2VJVPAy4Z2xGQN95m3nRuUBGraTZ8j81GifEx659vetJqn7q55iAQ8OJ/6qw9P 11dGqv0HF9/LfT7Y1ggNh+0f7ckd4PWPwIUU608LlPF+Fwqm3yl2thpwRwjsL9biJXqSNwXf yLOg2DHqbpD/iggh9yB35RC2h+53OpJh92QEJ6XWfOTdFgv8a2zkOOn+blCrZPsm7AGIyCxd swsyFNJuB4j3sNQ6s5YH9mpc7Bp8LT4RnH32obKvOG4XKWNGf7eByrhHvblmxyWLa+JHiNQw jcE+y4L3SMThjMmZN3wFyr/4yWMfSfg3hu29PAZ3Py3ZFKh/+9hqw+3PtKfu13GVybwDG17I ehVSlXu90vTzjNxcWfGcQF2kh1uk8ImaA8EVXNH6mM0xiDEk+Vt5M+51 / show errors; /******************** INDEXTYPE STATS IMPLEMENTATION *********************/ /*** EXPRESSIONINDEXSTATS : Indextype Statistics implementation ***/ /***************************************************************************/ create or replace type body ExpressionIndexStats wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd e 346c ba4 8ZyvXx5Pz00crszV/6C2UGEnE0Ewg826Va6GYC+7x/kYeQ/xoN6ifQVjNWUzOWHAfoZMhFMf bSV6yqgRqDsj06rPFzNqh6rUM1JoJuGkqBnQWDE6g5pZwAZ7UV0h0uK9c/5ysFVOTlWGHRLO C/6WmpqKT72GkSFmFPjGAu91DDyhj55vORTScZ9gRJk28LFKDDpGO0xPUjUVoi8/18FTZnpz 8EXhB7Bn1sh1GBTLWsh+3N50719q2T4ACzdu3xQi2CcWWRiEt3960BcLdjXuzggwe0yDcbjU sh3Ri3pSNeZKAyGl5cKWmYB5IktdhkC80OTulmXZFAIXb9hqWI7u3a4EqC5BzY1GgXBJ4cAd 0+EBxv9csAAhU1bndHIqK8zfNz32i3m9vvXg/mj00EmddvbNYGa436DJFe7DNhNF9N3QcTh9 1lLW2/6cVwvo7n06vJWz9xmFlWB8clERG1GZbmbiLEHRmRwUD13vs8XujjvpVI+zecVsW5gH kjAeV2gvxv5eddyvqfo5X8Ay3AvyZfCewXew3jCUqYrV4W2LwEaYwfWGqaVBh6jeupldgtwX idQkXw+Hjh++kkNEYNJvzpWoKfQxNecI3Hh6YwUR1+R3bcGPDT6wj3dBtg+wxS/OGhReSReF buGBfO8QYRZbfcSAOkBhHFVFw5JFqPurW/6ZXnLz3EXLtnc+yyq1kTQF4ExgmDxN/5aRUYx+ vDOQgsuXcr9F7hvyNo1rKo3hEdGDqvCGi4x9YXx7GyMK8qt2mzlJC2I3cgW+4SRhUp5+obJb A0fJr5AuXV5qJjB6tzh+K/PwTJ7/lrAY2H7J/FXZbahjtKkD0y7KwREe6FNo2KlO68yVJ0x1 le6UZMEU1ub89rkUZlk9QYkD0PXeMHBBF/ZzEb01xHfpDC3XQCN0lHuf4cad+VpcBLbnzAUt f5PyP8vBITn+4BixApaEMFGsOKNoNmvLodkXQWVUblOPGolTy7+kcmW0NcGV71/Ceg5Kz4up 7gbDbKStITddRgnY3FlALes3R2WQUZTfPmUAZmjOAeUQCzJRindsvXlNVyjtjlko8WRqVLqm mjXcG3ss0JjIJeVMkKnCKcPGetTWkGe27nLueZ4bWTqUtrmtkwGg2ZntNiu+qB8m0ij/8q8+ sWqBmVIkB5qO0ap7iMFUGNi7uf6YSWZ/lFIsT/7bQlO+tdLP/uRripGN68NWVwekZVyubbz3 wWElLvOVIZUFZkXjz0lNcfMbuwr9n+iWdynC5hgmDElFU1oWca0EIlrIwz4nsCk/1cMwvzkg 38u6SiNr370nVi8UUq+xanldgTcF9u4DeN3JEGfLBEjR8CqmXZESEiN9sWp77QjX2qBCB99z Dtd4qX4jhBMJ0zAH32SeeRmmMcOyV8TXxQBIBBU+mihjGiBQYFsC/sbmlBma32+bTa5EPbLY +83VROAjoEGOqS3u2fY1nEDRjQJl+YDXDv48UB/espMfyBhfeE07gVIem+weXkmpFO/HWQwI PNqhTWqB2fPlcavDVhCCk2ZkZxlt0LHRIl2bGczSo3zi6o4NHUaW/S78GTicWXGupsQwnyrQ cpD9L5LTtzhjUVFO30kiht8PMDPKjI+A9lWTbVSPmkHYrY7JHWE3Kgvk9uFFTmD1IN+RC0yw Y+6GLXk2/1QHWmHz4Qr8NnXNZSADd6Bgl5aVcmJQz7eV9cuqRD/1+O1M+RUOcjbhX/d5uWGB VLsfcKpeQ2CGV18TfEIbMVKu+koSWjyuGlFxnSFO+4KyXGdhcZj7K/jsujn+nrmmmeDzA9fb nGTJLTkjgqLWXoGjrfIpY6Y4OzRRyNhSZfQBKZ/wSnQ60QpwuB9DOnmmtG+MdNN2XdWNLfvW /F6ohw3JlFRc66UZ5aKuWKkNZQMm31BHSNfdFlV74qmjgwBP8bbAw35QykRYVCsxWf3YatJb /HF2pHN0rUFt+uDorgAN2oIH1u1ZzF6TbwVWnwoej62Tj5L0B7JkVIW3b3Ys81oXnjjDjOXC 1D9Mjep1oVpTney+zAi5qYwcYij26U+T8Xv7EHiz4YRW2lBRDdoKG1a7oNhw+jYXJMyx8gS2 c1Npu0P62SVKRdXKun5Cs33IcqC2xSPTO4IbWtdX+l5P19l7wnqM9KfpLVGKwQ8lhLMQOc5a 8LcOgqyYuiVcz6qpz0limw3OVajG9gOjA8GzHTSK3esYqVs742vJFSHIuvTP4lh8p4JJ8SU9 V7MOej0Wjxe0Jmw1IYP6SioecwV4WaoUs+u50JgFE3NKiiA/nZr3nfkZABBmcpj4Vc35uU+Y c0mbN18FDinZDDrJ9uDplqQkr0Hkhk+YsBNzhl5Y8BQqO/xjDRk+p9DCMHQthHKZYUg5WQKs +hXFpAobgqzsT4+E+xOGZ2RF9MqQFbG2Ug6AQnnFTXLFa8Ll6Koy8T0qHWH8l+jHOITsDBNF Jg39bNERxGFF9yPEvOs+zfTqVV+JD7DXtCOzW7qWg0sNQFB9Zz6FYu+6rxfHX5/OcX6eKMZy YHjHXeUyGmzOJyxO5Fo8qiRnGTDPysq9vpWuvxvIXoXN13NzwxvTul141xaDgp6Tlf/zK6Pe rlYlSiWZ17E1OT8solXD2/x59UcbgSZNBRmZYBhl2RvqKFguWycRmfyUmw7eFIH2vVgiCZ1M hAPo3jkyWuyPYDBettq1+sx0t/wWmUwJq5VGLaeGMojDrHiloOD0UAM4s5ayLLlXR9LIoWuL WAKS83KJ4jduHH9EKMmjOy1YzCVZHgHJ3lGAtmqSoiBcfoqnmFxN1I04ICc7zByNn2U8wmKZ TsqjIrIoOh9/wJvOKj4Kt7Nn+RGTrrERcKEnWpyjFAChlpvF0qYbLBptT8Cznb02HJ9nateY PR92zs3wMh/fVamQTUtLWaI+pQoGm4plVnOWdfyuan4eG+TIfZi1pj+SAUQ= / show errors; /************************** INDEXTYPE OPERATORS **************************/ /*** EVALUATE operator with different arguments ***/ /***************************************************************************/ create or replace function evaluate_vv wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 8 4c3 284 JrlvEXL7dKSfOz3G4ecS5+a34XQwg5DDr9yGfC9Vgg9/5tVsjVERmZjhN1dTMxotibSVn/L+ kVKPYYB9JixyX5DmaenZ02wt4HJ6chJyt8l8ZRH2j974zrtDCDo+SMRDiHa+Gs197W/cYRVM w4ALsVH9pQBvSjn2iN+m+WRkO/Gj/QL97K28N66tg6mk4Y/JQ1AS4LfxEnQ7XPk2Z+ti+0dQ llCQTdDjTkj44f0J3Bji6+gtgtz1BDkXYFYvhBEN4a1XBxvbr05uLIYaXFOalEi5j7Filtis 8wDc22KWlsne6TB06E/icXNrjUTR9HtEUDv9FtbrEKEB/4/LGK3ti5V05m0btv2ZboIUq+k+ xBetOrLnZ2IjLKH6YL/MviP0qJu5s9/zQon+AW9R6De+sTVWe9LClYduaaVnR9AER7ySG6bw tY1BlC78JX9qXPw3ieTdI5MJ1zr0n1sVV2sAYPX/RZubknjaRJOxFPx9BEK6bh+YVcHxzZ+V QteordYkmeZ1hzFxudrNKVD1XbtrCnqqEVZI7E93RqP0qdLnpEuWXurAvq2L1f6AkoM9hco2 q5wj8Bu8xByxk0PUtcKIXgzl0ixNkCs9vF7xDHGKWjJuG+HYM9DqiALk7g== / show errors; create or replace function evaluate_va wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 8 475 268 8CNy3UeizgkldrfNILQvDcIhhaIwg5C3r0gFfHRAv/9eL+20+3QL3nh+VFDWZrMtprqXFq0M rubL7c1TgYkHLD7akG1w+t+vyHD0JOk/jhOvKRHt1sGchv5PxixyKUNU0Y+XULyGQmRaxBi5 CgphEj2y5+4+d5cAiJQ9MscKhvvCvniDoxel3dqxKqj22B0kot1qSnw2/0ltEl87eO5A1ugF 4VNrmspcuNUyvs12cGqKoPx7Hqudjqg4doUuvKZ3L7r2ZyiifeCr5hl0t2MzOXL+FZyAMJ2n HZR8RT85U+TSUliun7MmHMFJKP7Pwq9iSXI55DE5l1phlq1QbHrmLQbeXFaoYX3Ud+gv6gbT kDj6I3e8kvt8EyIUYDG00YjlxAS3Ro3Pt2krcw12oXc0WpsywxPL1kgt6ngvh1DPHoQJ2Pnr +2S1FCzMF1Pk/7icBcptnb3RclAWR1BMqagBHRsUm8Miz/nKQ6nzHiMtMGJsnGFT1dywJO/a kBiYo1lgAuRvijgi1IPyHjHdIOiGm4dvXDPBMkw08LQJ8CXIxeCDgwBF0phM2zIqYR4PThNe 2MC7PJEuMj8FiIqOMaCVMDb/mA+qbQio / create or replace function evaluate_cv wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 8 1ac 134 33auj/wDRJkAx57MuwhmgWpEhfYwgwJpf0hqfHSKiuq4Wabv1reoqUmTUeDhZZTICe7c5mmR HrSLc43wkTJXuMq5Sr/BggWi9+75U3PkVT+7Q/gt9nALfnTZy1IReFJPG5HYuooRGvY4tlnf 16aSYwd9VvPabh4B+DfiduDjrfv/6jU97JFsrnXUfdLwqSgfpv/rqSW82TR6EjpODSH25soz Up0vRF5vP/I3+t4UW99tyrDxDRndEYKPY0VMGLhqGmOjM44Yt9YECVYW0wG/ek9KVbwPOK4x 4iDITLUIKPlRVHM= / create or replace function evaluate_ca wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 8 1af 130 V7M9JmC50M287STMLtqjR7CiM7gwgwJp7UoVfHS8vq7u8xoY+wTc/Ikby1TypJFJsGXpPfTN 1NpBT6AGBG1bKDz+9k8xGxh0xPjSTnhzGZf+oN5wAX50TsstIOpSDxuRNu38/6U9WJGjVJW3 Lu9Wzn1W89p2HgFVhB/Lf9tupsZtDidiA8hbWcF90vCpKEmm/4TQJbwKABNzwU6BIDxGZ4qG nxue6FbkieF8rZD6N9dmhSaRTEqD0jBm4jCxKKMn4K5rVzH0qJWsZszfB3KGOJ3N5clO8VW/ ssIeIhxcGJMZ /