create or replace package body drvxmd wrapped a000000 1f abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd b 3a30 1004 CcEnFs5oz+U7DY1G/NVFPLDlNHgwg1W6VccF39OdF7WUU/r1FGPYJxfiEE3xR2kUFAPo5zkU pPiHV+1UkMmDIYi6c+wILKqYzsofyj7ZlLdobixWWFSKwSAfDKb/an1mccdhjggqmL5zc3K/ eFZW3I9JnGYGUmytuk5l+uA/DfSwSV9DMtMPbH/2qvFfLdiDVr50cHF3BjLUbIgfXPrRhIiQ B5uIazAGCWnLk1PufpYHZXHoNG/Zu0/Sx1CGUlRA7NQsnY+xSoniNhoWZMcH4FiRazTit9hd HmDTncU+ChxM96xLg9k+QzFFepoMnEAxRUqie9j4J14JrBwYTY9DPxwvQ9aKgHv3nPSFM1LF 4gOFwgWELe79qGT+l8WRkWgA3VvUKnr+Ur5dwlDFvya0+ooUPtynz5CRfKinvWeqHJDHWo0W Bul/8EMBXOhOTfHxFwFcuFjbN9dfMVGQognGXzlv+decSTc1z4+PqzLN+c6Fy+enHayDqWbH yI1EyY9RlsrKmaNXsi0tVJ7nJ+FbiPv9dfxn731mOLWi1kbd9M+PYARRr2Rm4nemh2RyQjmv Jgu87IyVvc7xDD4U1TiivW0BlcFlWZ7LXgN1iZ3pqkxHhJMbhaonj0P2BTsuV2M73CL7Lqc3 blExBpk4RdTxbooB8XfMgFwWQztmoZD4AgS9Vihatjy3SUxk57aUmrmp7IMo4hsZyxuiHdUB hHAqpJY88JuHhen/gh1AZp4DBzxqCJ70llNsrSXg0C3Cv1wB9+GuQHq4LxWVjAmG2vKEW4aE AW+LdqIfYJMpsG0MW2e3NNiRiyRJ/yo21Ey8BiseDrPVfPHQ/g5J9t3WnDijCMatfFbZ1n18 T8uTJm0nk2RjTZsdfU2KEPXDMy+QZRAOL6Tzo83Mq5M79WdxwsTldZfg7dNX6FtBN1u4CZ7w 40mVIKbczG4EfJVp5KIIylrIy80wwKak9ftbCAWaZ+/pr+8zppX78H8lza5G73BGQX5oBGmu RDva4eAIHVoRdChNAjUL1OOm+0DRenA6GETY4/dNwsC4UifqMAS8l/gHiBaOKz7flN6DRbHY 9sbiJ0hWcQ0TYDEReJflGZssEQaeWk4GypyUE3pi+c10CosMomadHBDuv4HvvLMnX7GbFvuk V2KEEbkI8B33tcwvPdg2j3zUCXFBMkwtHesXms+ZyUpdWbHKLPY1Cqb/9veDehxqmkrLHBy3 VvHPHcmm4IwLt1QoxnpiarzuCGn89lWBCsyGMDQjUXr+At7FUUtdxZpthDMKI1XBX9VBFIZS NJhZNWCnzjwv/jT+8MERcrwiJP0y1iuMhpC5GFwiu3Mpry1CKLBrpabjkw+XHlmJOFyeYY5m Qzg8iW1cdVGrjBV3xT3O0CcOyRTV3zJ3I6/yuJdfkk2cF3kbWSbPRGg9MLR4wm9B62zQRl9c repuy+UcFvisD/7tBnhTStGS/qbU+999e7tN3A55IXTY0caGMZxhpe7Vmwlsrlh+e83LX9c9 cDtggDBEScKgG9fTdAtLcE33xvVTTWZH/a41CttRHkkEFRlrsNq06hFzLVm79uVjLMZx5xsS gK/5Rd0AqLpuMkS9iiJUTBiZQYFPol3NPDSdsgcL5QGKJkNf6cqE7AvLAMJQrhPEsDPe8qAR g+wgtSrvC/JbqkCnGSKNcfvpUnhgBgsqiAl0IpMJpj2etcVGPE1K0TdxKJaPEzfZmtmx3x0v h3u57S6JDXjKOTl3Vtd02dgf5OYq4xpQQX2x5TwCmu1wMQF7MhpZuCWiQnfwCgzYoFcyhaC3 pGWBTWPrQukeMIxCHe21QhC9z3Dik8MNiNfyOUOlelaelPDJc2anf5u6lsg79xtIVjb3oviL rY4Em9KtFtoLRoJcyx+jefQ9LLxjlciinE5LepbmAOH9v4jGBNOCA5AnHzcAPql7UJqrucoG GIBcvSdI33rccOIA7nXkM+6LB1WnLrm7kzRojio2rNnA+eWe65GNpVPRh2MNQvaovYIL/v6n RJgFubRknYr8vyRo+XSk2ZEJLhuFLajOhrDNzWFsOrBrWATNZi0xFEOsdZKToBkOPGBtd0QA S/jmGLGLXLxJ1eftC4D2dHPlrV2pG1xJ6qmrmO2CvgX5whADCw8kc/E705OJKoVidZfTfILs vJAtsA8DVfhPxJ08mM1P2gYRbvmGzfi/BzoC2EgD+Pi9EgwELrT4BRPNYvhyD6IJcJ21gTj2 nbXOMzNIF5BhBgH14i6sIjVQrH4WLxlX+USgCtW4K1k1SLbtOnxPJrp3G+7boV7m/WNRj/L7 SV/FHziL6hcU39CXCh2cbyhHGssjAjEIX170BTXO9lKbplAcMeA7RKJsFUQ0lx+fGKk4kzAQ dXucArGePTrc+yrd3h0eB7zYfx8snx7N4rQ10wYnm+S+OJKbY9HAUNBWOAYVsiMJyoveAb9m i6cZa0BpAk2dqKKcEOI/pX9iD8H8lxmnIA/9/t4SfCgYsJ5BAFyKTavf8kQDDNy6Sw4VqsRe D+ezjBhuQcOUoWEbCMNKQk2lso3t6DaBnFed3UJDzcjs5taBWArpvRxzd5UVok1O8XO9hxze rQQEzYnWt4hePixOiZyLAuJChnvgnYR4Bqce9/BTP0QpIK9O3ICKNsgRS7AFuTjivnVDRdnb EjVljqLSuElCHWOee/pqbf9p2imBU+hrbjD8pFD2XaCxhaFkOKuS8zMQblyJHDSpLd5xpVo4 g/rLtVcYgP/ra7eUNrdcL4uPeW6GeFxtMiKu6eMYUQbS7P1mZmkJlH/iob0nQt/G1wNDcbFq w+M0r2UiTxuCYxmeXyM41xO+lhiXe/LYcsx652p4XSLUN7KyYP7kfAeVIvII8rdKtuR5ZgbS b2es0NqYWdm7VcZV9lwWcLmeZQnh2XhLbmCtL35EMjsCB8kXh7rV5hCL7hP2xLtVBRxwiB6C 8LgqVtanxhbfDdMjufVrq9eykBus3AmBlduQJ4vwx0kKOAXtpgYWBYdkKSn1LhF2frLNZgNB eZEBGtUlhZlW+FLiglM8YS2v/FatQZ+lo5AAPZUeNnt6Aa2HQXm7Ds7VmLlSWwftDKH1tOJz aYVH4CbNr7pj8YAjEjxHIIcdvK0AkO7mVEOtnF4SlOOgOuXsbzC0P72ZGHcMFFqprRnMJIVQ AcPetQYB9hagPMdUq7rrM5rpkziB2JEJh50w3pFwDcPkg83q9pnYt2YT9ShT3bx+14GyeJSL Pk3objehe/e3Du0aVDw4ftw0ij9M2c8Ne+yYXf1S+jumGQY+ZBjHfk88Tno2aQ+jiezQ9JKg BTuez+0WzTPnFq1kXewP2F7DeTPOuZDh+eMZc0iYCiDEnSAgu2GB1/h4ICD8mCQZuRnkkTub TicWv0VsEMe+8mqB0qL+XmHZG0SQkFP6i3bz/Mec7b8DIyC9/SYrEWfTe90ZEYnlZAL1BdWF 1ov8Bpoe4oMTabWa7Y0y68aKZFohilWsG1SzOkQmyxLWAch9bq6qd2324kjSsuCO5EWKH0rq l9UwlAYyvln2z7TlPF+pgvPjVq7AQRuI0M0bp45kpMXtDu6UqbkxFEGqdybjiqTRmDF3SnrH B9i/1xPii5mEFqVclUMqqeUWaTNxeVop8ef/3Q3h3ggAXn0M4IKRcDV+nxerAqkX8ZRjd+sO WSICYwZHdxXJpwomgxMtqtF7NnN6BQiWYhLP8C7ypAllVc5AizlcpOQigE8KxRiAiD3xhXuM 8UEQPVQlWYK1IQeWBVE8Ik9FVoXPaQ1qZ76aR9AJLW6fC1GtMSbjdkARWMUbA8nVqlfotEeI G0j3V97QbO5rbQFHZxbyyC97KDV1gzPdNhoxaN9kI0noRCHdsK+5MSk+vtFUpY78SdmvluVb UETMILIGehBxZpVgkx2RL27TPFmBduF01RT/XH/WG9SxwODE9Q7U/DyuA5CoUodi6xTsoL1I dyy0Vn9AIf1i5idLLn8sDgaptK1FNm8r/GvdVOb+B18Oyccm3qc5IVA96JZ0tLndysNg5FtN quQf9NtCbg== / 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;