create or replace package body drvxmd wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd b 4918 138c ekNPhMvsV+nkSO5Omb9v/1Ck6cQwg1V29tAF35si+Oov554FJvzJ1mEsBhSpVrOHVZfxZvL4 U5bm4lKzDtCOE82ZhdCdiLwhGhweO43SuW+v4mLLwQBqqK3y82Af7koDLhyaS3jEnXMI6/1v GDF+K0wXOINxpf3Ul6UnCD3xABKvwnsusXxX1Zd6BlJMwGGGXPGV5CMslslflC7TD0l/9qrx X6+gc0Cc+1/BLj+NCPFfwTKV0WpleyjZsDYG95k1f5HuQQPMdFxToUK3IPk6TSzWq9BqxcN8 +VdazWkpCWfj/Oi4yt+hb6d4LvFczxc+CB4YUfzulKjn5cxZPnKfPToWcavJmBuX6zgZxPgY 4dJnoqzqhlfdl4D60LhCzGxC30ChaJH3NXjhLcH4NDSIY2yXWgoSpihf1f52asD6DGtUHKwY m34TLwBeJwNDVvMDsppsiN3UAeEtLRj/rTajjlKob1JCk+opxeXZ8RdcYjBY2ze9kENFkKLg DNA5GyKKB4A3y/TdUs+RA/iGmD9nbgDKSKRpsaSiAXp4uFWCyocEoPnfRtRXumdoxbhxSXAd XqSavUXiZSLMmPKPU2CPRWePtKt+amTv0VjhR+rBeh1eKn+a4mn5NiHZ2WWWk0Tv8fVxPM9c QPSPfCptoWF2WozpVCu9Bg8RINJCu+hlbiUbgiyp1Dxn5yWPm/R8jfGh5/5moexNasWR+af3 Gj7kNPCmOVsTYpOud/UN8fb9OsBbw3c/6gM8v3oUxNwbAed0sOsxg2W7WHqWMOiQNaI4n5qb rUyjCL3Eyknyiqinm0geVvH/t6jLdjbHCE0J+aRja4aGhDpvi3ZEH2CTQwdtmVtKK5vl0YK1 rcziOVD8m4h4cVunZGdeIkzWHDv7sodA3tcs6N1L5UqsajB7yTgfgegxjUJMdvuA3tCvzIOE uAnSN6L1rN6NYCYBlOv7zPoRK7NYlRFsuKIoevvQ3RSI7FBPFLz7vxgGotpedPqWH/57vRVr dtBKqdbsjxbPhoHf5uccLRLKSk2M80h6L9y473caXAtnKpSg/Ofj2/4wrJR6DtM5K1+9pDYv Rbn72epuahgEQzIrstHczZ4oarHptXwdQBV7O135LVxkh7HcTD1xulN+BcKTx3j65RkGDxKe t4N2Gee/cy3q3tG0qZtAEMerbCfMIhjhlLk3nlRnSo6AOhO0HybOnIJW1bF6l20T+gobnCRR H5XU9YFRFFD0lS7n+BRoNDiDzhbuEZzMaQQLPjzfxT4TN5XrZJ37f0kJ6NXIuxc12ab/9gB3 IkHmmssoQSQbk8ObAOP77hyQ7Ps9uEfrxYr9Qf8MEOKYIz1+brlkHD6uEH+1ifwLXilyF/jv /HLvQymWWet6ntXRH/1SRzEnZPluUvS3kVl2u7q3yh2vpyq5rfV1/8wAOpLS2DGyo0rc6kUM K/w0/rBJKH3vqCeelql/9itDLqfqOExDfrfBPiiCE0jEOBh+WauLQD4KJJc3bvd+MRU4HkQK Zz4M5YyHbvBBSw7SAY8gsNmk7DyDXiP6jDRfQ8AWf6SNIshhNEt9QZaTnUrRkigO6FJ+jzI9 OJBTYYt8fDRuuXIiDQ27vELM+o8m8RCwWUYtjXZ+XX02wSRGpwbbp3x8OZnidkKFM56TRkLr fxF1VL+BNoRUEoHD6gv0PCzZd/OYVpC4RzKvkfXDX645gSHhctUuuSu9G3wXoC6ND6XYtQk7 ESBY5PX/VDYw8hDVsGA8/CZV7cSuXub6K0Cazw0UC/Hc2oxdJdUUHNdlIqdwL66lnGzhDmHO Ll0Yn7ZM4VOrh2pJzf2qYle6v4APCWC5O1fwkfvz6dfGIfyI6oXh7BQlWIMDxJKv1evZ9e7K QYYavsOc9gQfVLlOTxF8lCghtaNK2K7kec8vmWrD7YU+M4qX4Skpeo7mJ3LiSUYLYD+Gopfl zCGZNxs42SIH40muTx3EDM/J0CvkU6zeQmN5gFQOCY+eJqLfrBWww3TCi8J8RwQB9m5/sXUA 2JOZEUz2LwADkCeb5OOG7+mBujp7f6IobdESWUGSCjBVewbXmiw/es8SxrzP5K0FG2NN7GWd 01l7hLYYEQif+hyq+rkZc7jOvr7a5FLGiywiUE5LOr/Euz8VB1YZikRZN1PiK2T8fC5hvdD9 CMV5R4stQ1I67mpu7TJp1zGYBXgHujO7JL0N3c/5TpzWOuRVBQX+v8d5MKWGIr0XKLa7cxOx v2QTmoe1zh6vjbv7Jcy29dvvFfOjN/lRGl5PpCmDzgF+2Qp9cb3nbVLctmtAZ+rdCHLdNcRC kJV311nSgySSIPzJDkJ9JRtLzOyZ0YhQ0lq03UeW/+O6IoUDB15FFBO7/qFsUrYQMPTrzEC3 PgU1zjleLFRuisBpMkYKOEzY14l2QAzuXHybwKSewJOC0d1/puscZVP8sZNDnWjNy78GuYFV +046TsGrKdmcxb/dZbw39Pax8fRnxJ9mWOyv1xCEY4l3Eqo+AvI6ljsaHAlWOh9LhkRQSdje SkdyczE622h6zMlBA5qdJGgcWmZA1ykD2jprJGqkt7zXoKMUMUpUXmTuzzMkyCWNh4OOP0+H SpfkjBjeTpoQCq9Qo3BOwKoZ/gO8nE7GwrmabpPVUF2w3NgjoSl+Q0kxUSWKsS6QhDHQLrhn wJojTFCBRQ4egTaAtv/A6bsrylfrVKVa6GmADfnwttBusIScSVOzf3QVdoore3NorooYXOwH hRZl3BPhUq4vWuXTBIIQrHFBO6XPFwPxnI1W104VRcUiDxQM+hlvRiM427pFumY+pEQr6mwZ POciqDM+uZFNf0XqRkRWJswYYg+X3KVMutspIx0vz4p4aq8h/lL+i6a92HHm7PJwpTk56xS/ P2Jr4qClaSwc1d5OaaTZ+Abstovc/cUetvBwPRbWb8YUZQ2OIyMZyLIFr5FiV58T74i/sPxC 69LYk6BVOYgHMWFzTbDJd+hSz/Z9DreBbvXyqEzx7IdwUK7rue7yBYM5TsD6CGdBeJsjGvPq vYnhCcB+KkgS9eTphFxa1mqH62+kK9meem1kPQ6nWxK4DBwmhOkAmm8FDyRCZg+ATW2snJnr xekY3lguRBmwDxUJCeXCRBbddrvfLBFNIcW+qgjClI4YwpSOujsRhu17ukdBMljDeJaHJ6t1 YmqgBgESrBGRN+UWcotV2gTIlgVSPfsW1zSmPBplfFrBQ3oRE1cKG1+BY197WFGFxAW3LZzP Tw+bY17fDKrFJ1JKgBKYXPOsXg+rlj2qi5tkrZOJ/7EeY4cxJj4fMr6GH5iOk7oiNNKMy6rm 7v75uLFoHD/aaLwkISAZEPgzLk75/sS/mj8gGpuGJxafRT4Qqr4ualXg6JeqXlH3Rv/JSEut xFT8iqqgvzvEbaNeKqId01D7PGC3kRDpGrqHNXa0PP+dK0wNkOC1mg2NzOvG2GTjKkeBxCor 9T81wmpNLaBJe+pNLA0tckPwuaQbCA8f7eu0H1yxSzLBLg2h/c+0wsmAZ1h949hankEbiNDX zMxYD61pJzVquvy5VYhBmnjeHFjfYlQ7QVPvrlWojEwQmYylFS8vjnjgAvUPPTQ0+5rT4ZNU +l6yjYg1SVORj44jCKkwX5YeVTRDmWlJWE3yKrLCQwtUf//18qADcUBDhxnPTL+mklJhhk/9 0i82saFjVgzo9pSzL2vY1pLqTSNYWTeJTXhGPIhj0tKZ1fSQ6A/p27qcNMzlD1MWhc9wDdZn 5Q9y0CXPAwQh8OYRfA4sf9KQAtsNoMYG/qME1Xrw2dd2AzOSyxxFy0o4vVieUaJESVCJ/vUE jSHbBRgrTIZhh8v/kaSSivq2JRsWMJ6hjZQObJMETVYmy6e4QUU3Fk7tX7amHV411xRdx3x4 VhNX6qMvxf1P2b6+1kbbCvw1Ap/03entobcRGWDtyZ3HB8nlgj7jAKIqSdaZX8tahGefAsU3 PacnFlDxUJkuLoUZQIOeJ6kdjaySR4/+Aj1cSj2IwwiVUesHIVSM7B1rC8pk5uegC6avHpZn HAUw2lxtdXu0p35nz7Y7YRRcbNDGoc4azIEnD5gcApfA2ykroElRfvPc6wTp19pwQoXvABB6 MslTh31J+tHZDC5pVkmGdIUovhSKmXcxVR12684lHHEdD6IHiAEwKkwTOCwg7Dzee4gFTNKI d2VQ3rPxZIOEATmtulxxwC4rf0RFdWL00Z4D4bT+Tq7fVqiduYZZ9a1Ovie1A6kXlo53IXG9 FY0DjFqvYWnbl1Eja9/+SNqLaT6D/uXWbS6YL45c6HDoah5B3+l8ZCHYzcOJmpEDT5rWTYCR t1qLbtiMLxpFHVvQhsO7angy8dTyONMKGcfP//9ashH58P9G8EDlYHTWHrOIMAIeR8iUfgW/ fVq55WA/0wa0w7hoko5OoAJ8J2oTIQkuqmJqqrH+fNy3AM0g2eWQ+CrvDwg0TRIEY1MhabA7 wIRbCRMTM5X9EvWRjjaZ4P0h/Pdz0K2FwsmA0npkg/d7Xkif8BNUfm1eZG7lmfLH0Rq1ZPtO XJAfyISM+IeRIW5wmDFol6zJ9V0E5JVkQsPqL1b4ANC3S2WkrcdMXOXENByWXPutFywiFrOP ZDch6V1yJBkqJO28c/seFTo/IpxQYi/fnFW8+HPBD6rhqYLH6sUew/VfYShgRb2p9cSbAJAq KLUqFlJMZ9MGSl9i/sgWmOHFvg1pcjdDSZsXuVcY67kB1+Iztd7A+zYkBdcm2JiuwXt3EJ/H wvOK6ve7bxd3YsjNkxLhO0dFuhOHbAG0pBKhVcBuVAxIT5GZJTd83G+3yI0azX/rMSlYVVAj QSHF3zaOilhA1o99Z8qvqXCbfbcAF3J+Z3W5NyueZmoPj7iflhIQsvb5unvSBLraXzCNPzna Fym9DJb4WLyWz5E8Jg2ju7MK/giSLLX7CjbTfg== / PROMPT ... create ctx_user_session_sqes view create or replace view ctx_user_session_sqes as select u.name sqe_owner, s.sqe_name sqe_name, s.sqe_query sqe_query from sys.user$ u, table(drvxmd.ctx_sqe_tbl_func) s where u.user# = s.sqe_owner# and u.user# = userenv('SCHEMAID'); create or replace public synonym ctx_user_session_sqes for ctxsys.ctx_user_session_sqes; grant select on ctx_user_session_sqes to public;