delete from mdsys.OpenLS_Namespaces; INSERT INTO mdsys.OpenLS_Namespaces( shortcut, version, uri) VALUES ( 'xls', '1.0', 'http://www.opengis.net/xls'); INSERT INTO mdsys.OpenLS_Namespaces( shortcut, version, uri) VALUES ( 'gml', '1.0', 'http://www.opengis.net/gml'); INSERT INTO mdsys.OpenLS_Namespaces( shortcut, version, uri) ( SELECT shortcut, '1.1', uri FROM mdsys.OpenLS_Namespaces WHERE version = '1.0'); delete from mdsys.OpenLS_Classifications; INSERT INTO mdsys.OpenLS_Classifications ( criterion, classification, version, characteristic_XPath) VALUES ( 'address format', 'by street address', '1.0', '/xls:Address/xls:StreetAddress'); INSERT INTO mdsys.OpenLS_Classifications ( criterion, classification, version, characteristic_XPath) VALUES ( 'address format', 'by street intersection', '1.0', '/xls:Address/xls:StreetIntersection'); INSERT INTO mdsys.OpenLS_Classifications ( criterion, classification, version, characteristic_XPath) VALUES ( 'location type', 'street address', '1.0', '/*/xls:Address/xls:StreetAddress'); INSERT INTO mdsys.OpenLS_Classifications ( criterion, classification, version, characteristic_XPath) VALUES ( 'location type', 'street intersection address', '1.0', '/*/xls:Address/xls:StreetIntersection'); INSERT INTO mdsys.OpenLS_Classifications ( criterion, classification, version, characteristic_XPath) VALUES ( 'location type', 'position point', '1.0', '/*/xls:Position/gml:Point'); INSERT INTO mdsys.OpenLS_Classifications ( criterion, classification, version, characteristic_XPath) VALUES ( 'location type', 'POI point', '1.0', '/*/xls:POI/gml:Point'); INSERT INTO mdsys.OpenLS_Classifications ( criterion, classification, version, characteristic_XPath) VALUES ( 'location type', 'POI street address', '1.0', '/*/xls:POI/xls:Address/xls:StreetAddress'); INSERT INTO mdsys.OpenLS_Classifications ( criterion, classification, version, characteristic_XPath) VALUES ( 'location type', 'POI street intersection address', '1.0', '/*/xls:POI/xls:Address/xls:StreetIntersection'); INSERT INTO mdsys.OpenLS_Classifications ( criterion, classification, version, characteristic_XPath) VALUES ( 'map bounding box definition', 'by bounding box', '1.0', '/*/xls:BBoxContext'); INSERT INTO mdsys.OpenLS_Classifications ( criterion, classification, version, characteristic_XPath) VALUES ( 'map bounding box definition', 'by center and radius', '1.0', '/*/xls:CenterContext/xls:Radius'); INSERT INTO mdsys.OpenLS_Classifications ( criterion, classification, version, characteristic_XPath) VALUES ( 'map bounding box definition', 'by center and scale', '1.0', '/*/xls:CenterContext/xls:DisplayScale'); INSERT INTO mdsys.OpenLS_Classifications ( criterion, classification, version, characteristic_XPath) ( SELECT criterion, classification, '1.1', characteristic_XPath FROM mdsys.OpenLS_Classifications WHERE version = '1.0'); delete from mdsys.OpenLS_Nodes; INSERT INTO mdsys.OpenLS_Nodes ( name, version, OpenLS) VALUES ( 'map response', '1.0', XMLTYPE(' place holder place holder place holder ')); INSERT INTO mdsys.OpenLS_Nodes ( name, version, OpenLS) VALUES ( 'route response', '1.0', XMLTYPE(' place holder place holder place holder place holder place holder place holder place holder place holder place holder place holder place holder place holder place holder ')); INSERT INTO mdsys.OpenLS_Nodes ( name, version, OpenLS) VALUES ( 'geocode request', '1.0', XMLTYPE(' Post Street CA San Francisco 94102 ')); INSERT INTO mdsys.OpenLS_Nodes ( name, version, OpenLS) VALUES ( 'geocode response', '1.0', XMLTYPE(' -122.4083257 37.788208 POST ST CA SAN FRANCISCO 94102 ')); INSERT INTO mdsys.OpenLS_Nodes ( name, version, OpenLS) VALUES ( 'yp response', '1.0', XMLTYPE(' place holder place holder place holder place holder place holder place holder place holder place holder place holder place holder place holder place holder place holder place holder place holder ')); INSERT INTO mdsys.OpenLS_Nodes ( name, version, OpenLS) VALUES ( 'OpenLS error', '1.0', XMLTYPE(' ')); INSERT INTO mdsys.OpenLS_Nodes ( name, version, OpenLS) VALUES ( 'Unknown OpenLS error', '1.0', XMLTYPE(' ')); INSERT INTO mdsys.OpenLS_Nodes ( name, version, OpenLS) ( SELECT name, '1.1', OpenLS FROM mdsys.OpenLS_Nodes WHERE version = '1.0'); INSERT INTO mdsys.OpenLS_Nodes ( name, version, OpenLS) VALUES ( 'Oracle Mapviewer request', '1.0', XMLTYPE('
place holder
-122.2615 37.5266
')); INSERT INTO mdsys.OpenLS_Nodes ( name, version, OpenLS) VALUES ( 'Oracle Mapviewer mbr', '1.0', XMLTYPE(' -122.260443,37.531621 -120.345,39.543 ')); INSERT INTO mdsys.OpenLS_Nodes ( name, version, OpenLS) VALUES ( 'Oracle router request', '1.0', XMLTYPE(' ')); COMMIT; CREATE OR REPLACE PACKAGE BODY MDSYS.sdo_ols wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd b 2696 d8f f3xORYJn0hGFqZv5jfMCMvRO/Y4wg5Wr3iAFV58k+Oov+2/Cyc/bzeBKVz5g931UTVbeoibw H0Q2eMz9u4OnscAbsnx1mrzQjmzxe354kDGUgzZmmpXGv9W8OLwqSHxFM9itl7nrV0wBhcqQ y+a3hSqEBcezsp9ScEZX1DWPREy05oVOLR7IzqTL50Q1u1/dbquvChwFkDjmFj0GzL8d5PZG oRG6jUztt51bV1/hH1X/bri5C5G33DVJ3dv+caxt7X+KcYb9BQEvNtq0dK24XbrKZd0yDH7g Qi3ByK+yy2Sy4LZFJukTqiAlsLKbYfrUqBYxzSWQPApurruNoqDunFyfUh4vM9pawnlF+vHe wlOun369Xp7/ZQVtxO6WHhTZb0+2ykdcx1+PpZxMm0/GFAUFb8qNq9pKM7rC2acp6J9Gh7er cSU7diGdHQWy7UrlwDN7vTSID8Rmaoi/eyUQlMjSCUv2XEfJ5A0bPcmCsFRtS/TPnNbfUjvH p/VxBFvEnvrLviGSPgeBANOnQAREy0ng6nJ9/cfGgtjPbU/BFE/jbi9YSr9iaK9FQfe0beYk nlulJJ9+H78NP2qMr/Ora74hd1kWzb9A6z0FcLo+DOGHcajRgj1bbD7RpolmifiwfEhG/2xC 7qiRc5nyOs1O/eIPmFeLJv7cf8Wc3Jzb8NoIIXRzBFnICbJOsfs0Sgqm2+qm4yS5hRtqhRVe VMsQdCxxr2Y4DjaLuR7qJPmljIemWOuFEAyKqosIVfDJsVcOsfjQTk7HKmaCAB06N4hwuEov cs+WfKxC6lpQhDgv7kGmbC/K3hSrCo5N0MURQ8vkB2qrPPjdyy3/CwlCSKxqtLBKLuaKQC0p vkhZZixd55iJxzfKJpRKCVEDA9tomph33Pdglm8GCmD7QIyvQjjvnnI+WkbW4sqZ58lFMUkT ECTPGSXDDmJhBT2bSC0HMADkJaojI/yq8r8e+YZIjX65Jfhd+Qo+2vqLTvn7Edq07b2wTM3Z I5ROWcBjKX344NYFbj/F1t7szSaFHsHO0VV5W78pkpHu5PXGuKqssEDbSGJAWaTlWuWPrSXb mcgukJEhBN1VvsnEuq3LdmlUFyzw0jg65e/GTuRRe1cVQaKxjzZEMRz8g3P3+ZDKcwCrgTaw 5m0hjmkbhtw9KAG3rFNvH74J4KMEUaUcFAzYU8I4Q6gM4LO2vBOYwyniwurWdgZD/pr3PLM2 VCnMWT6tbgbAcTFsREzgo8Jejcr0sv2ywRu83TQqLa6EFz6z+D6fXOEZFMljJ+fabLQpWXCY K6ClhlKpGHRZ4ShTRGaGKzAfgXd3uGJbxjR1TYkEdKXqWysX7fxRKZNUTJFrAmwv2xCmzV4a s/2MQkaHdpKgVOLx+DfoFGvkyidj6Qp6YFVskZ44cl8VJ+lB2XFvTnkqKy1WnCwDQnZEYYnV EW9QE57Hou4RAZOPUCfT11ZlSR3iIbGpm7R4WVlNBh1f8jdkkSk1s00vM/KUh/o8rSzMUTcb o41OZpSgd1ghMHnCCoKfOK0osuXSwhuWGHm00Xz/L2q+pksf7hCHZMN6VFfjsKRpmaJq3XyE TTRmbvZbGBPkSTs/wBO+gfC4oy3vnG4nezQWfoqGoq/nBR3RWZwIHvuZuZczRsYbyr3p44Z9 R3+ZQPUBR8sRrsOcFzjLFoT6IqnApom2wPIhIYQWA1X9K/UzjmlNHIq4HLp1RfYp9cLlq43O SSm7cBLHZ67xXyrrlhOPbnh2ba1wC3IZPLtPaE92u7THb7JzSQ7qmK4qJ6ldrRyZq3ZGpEPy e2+isrxc8KRSiHr8JjXAt+YP5WYX1Lput2uvxE2OQ+iBVC5yr8D995RcxdAkZi4IoEM6x0JM YW3xkblgNPY4CiNC/xVy24ieOkT7TN7bV/wtFRw2EqE4clCjmfjfoDmOcjKLdoxmlktpU5QU YMGV64wNVU2IBQjnp1AK5vr4Iwtr+1oC6Sqr3BN583Kl/XkeGq03wMTlApS6ga+rUzjXVWu2 XRczy4qNd4MGmCUM9pyYFBJxzfNy7Cj4czPgV0afEci5b78KRt/9an6ZECXgKs+X/xlxGUlP QCDRB60ZEzQ2BrV3sOXeofB57D++pwJF7I1m6EE9TGv9NdZFbG3A6RAmkQHcO+oTHcInzBwd 5aIwMt1FPOxwmtQJHFTffw3ZiAv/sSHd5hjpvmjJJUP6bj7oVsGX2quQ6gaJIosN7fLJ0nmR S4RLcafZkRoj7XyRvkax0TUkLm/tAssQWLLfvRMoTz4BJMUY3X4mygDtOa7Oes8yPyKr4YLA /sjYH3NDGwWW37+h8GBhNIUE47eLagKE08pOBmr4Xe+hn51iu/FHmmO18rkzLMBEcwj8HXYL pWyYZGXuM5X2/yUn3hfAM+jhEpNY8cS5jCVGV0w47F+lNeIRTlP5dYo0rkQqaeRNG5m41VvS ge3gxDgda1b7M9lzTj2I1q32NgbW+QqCuW/6EKgh/Px9f09JeIzCqANYGZldv62Lflg7H/iY BwM4at5AO8a+dm/sab/RB7iwICG+OB+GmfyJgNo4DR2n4QW136l3kuKEgj+tUzNKxEOBvapi hKBsL/NcvCICR7hXgVYr4qet4NL8SRDP5qwIy4r5D7ZZPgS4oI0iTHu5xKED3DMoKe2YVEkP t882EmwgaBQ+kLzABqPWCt8UlFhJd6zJjnvW71hggbysEmdqWad2LwZkXT+3iilTn8QwQWJh i+CYzlNxYv7ZFNVErdSk/NXh7cI17QbjdCq5rDITm7XyuSvCrp8eQxu9JcZzbSEsMMzjrgnP Hf5Dy9MgRRJIDZgLaGLaqUiDmYvGbFdpXXbPjrlRqRcmHgeoLsVJ9yawbs/tbycMCD1w9jXG iEd+H8boC2fqrS0un4abFmT0ZGWpzMwLt59YNWosgsOALE0zF7KAyUzJji+WTaXv4GBRWTXl wPSgot7mZzaIqJZYfxNOpS7eZQlY8MN1nm3VwRRnU3o6XJgJ29JdUOQa0aqBtKooNP6Bp7gJ 6675YsM9ddKt20H1TJaKxYTfUpPtbwHL7PUWqRO1ZlFulvw9+qqt2cxCFmSbF/N79NiqZvdb p2j7g4oTQjcsMBthUabvmufnqTCHcJW8OE4nB+22M3++4PrEAvFRyKph17HBDTJMVMF+HMcY spS9+HW7LrRHQYzlH9VLqK9qTL7bNwbYE2SBff5JzjcY4KDheXJFQ54HyLSzJxVjDynyBFh3 eaGsqtm3DmAAWMtzWYX3i1vINkDRIr7D0Q7AJDsPRuPQLiMmOqNx+b6JI0yUFnu/p7xTwXxv QQT3tiu99FDDkATBszjJ+xXKfH4vqslSs6CIOzQqWkmlCiQjAJI6wYeZHTMpS5q7v0eVCzkA /8bBmTOXksKL643y9lCeffC5paLf+QWq++4BZKk= / show errors; GRANT EXECUTE ON MDSYS.sdo_ols TO PUBLIC;