9 Replies Latest reply: May 3, 2012 3:29 AM by odie_63 RSS

    XML blob issue with External table

    933984
      Hi

      Let me brief you about the issue which I am facing .
      I am currently using oracle11g linux 64 bit machine .
      I have data in the form of xml files which I am trying to import via external table .
      My current situation is
      I have a external table

      create table test_fingerdataN1 (
      FINGERPRINTIMAGE clob
      *)*
      ORGANIZATION EXTERNAL
      *(*
      TYPE ORACLE_LOADER
      DEFAULT DIRECTORY test_dir
      ACCESS PARAMETERS
      *     (*
      *     records delimited by NEWLINE*
      *     badfile test_dir:'test_fingerdata1xt%a_%p.bad'     *
      *     logfile test_dir:'test_fingerdata1xt%a_%p.log'*
      *     fields*
      *     MISSING FIELD VALUES ARE NULL*
      *     (*
      blob_filename char(4000)
      *)*
      *     COLUMN TRANSFORMS (FINGERPRINTIMAGE FROM LOBFILE (blob_filename))*
      *     )*
      LOCATION ('employees.dat')
      *)*
      PARALLEL
      REJECT LIMIT UNLIMITED;

      Sample xml file is

      <MainMobileNumber>xxxxxxxxxxxxxx</MainMobileNumber>

      <PortraitData>

      <PotraitImage>/9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a</PotraitImage>

      <ImageType>JPEG</ImageType>

      <ImageCompression />

      <CompressionRatio />

      </PortraitData>

      <FingerCount>4</FingerCount>

      <FingerData>

      <FingerInfo>LeftThumbPrint</FingerInfo>

      <FingerReason>Not Applicable</FingerReason>

      <SupervisorName>001788488</SupervisorName>

      <NFIQ />

      <WSQImageCompressionRatio />

      <FingerprintImage>/6D/qAB5TklTVF9DT00gOQpQSVhfV0lEVEggMjU2ClBJWF9IRUlHSFQgMzYwClBJWF9ERVBUSCAxClBQSSAtMQpMT1NTWSAxCkNPTE9SU1BBQ0UgR1JBWQpDT01QUkVTU0lPTiBXU1EKV1NRX0JJVFJBVEUgMC43NTAwMDD/qAARRklOR0VSIFdTUSBGSUxF/6QAOgkHAAky0yXNAArg8xmaAQpB7/GaAQuOJ2TNAAvheaMzAAku/1YAAQr5M9MzAQvyhyGaAAomd9oz/6UBhQIALANVNwNmQgNVNwNmQgNVNwNmQgNVNwNmQgNvewOFxwNaLANsNQNZ4gNr3AN6QgOStQN4CQOQCwNyMQOJCAN8CAOU1gNPSQNfJQNXzQNpXANazQNs9gNiFwN1tQNvwQOGGwN+ZgOXrgNvgAOFzQN8iAOVcAOCywOc9AOThgOxBwOCOgOcRgOTlgOxGwOXmwO17QOmwgPIHAOSPgOvfQOjJQPDxgOQcAOtUwOWmAO0twODBQOdOQORSwOuWgOfGgO+7AOrHwPNWAOafAO5YQOfIgO+9QNlIwN5XgNqjwN/3wNsbAOCGwNt2gOD0wNwSgOGvwOGqAOhlgN39wOP9QOGwwOhtwN8AQOUzgN1zAONWwOFRgOf7QOCKgOcMgN/XAOY1QN+HQOXVgOMpQOoxgOApgOaYQOcwQO8GwONCgOpPwO6LAPfaAOGoAOhjAO22APbaQN0IwOLXgN5jgOR3gOgvAPA4gOp1QPLzAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP+iABEA/wFoAQACSWcEK08AAAD/pgBdAAABAgIGBgQHCgQPEQAAAACzAbWytgIDsLG3uASur7m6uwWsrbwGqKmqq72+Bwmjpqe/wMHCw6CkpdMKDJObocXGx8jJzM3O0dgIlJWXmZydn6LEytDS1dfb4/+jAAMA/wCf5/8AX5/0/n/T935/n/b+Pr7fb+X/AJ+f75zJ9f8A37X12128/wDi3n4+fj8vx5+Pj8fH/b8P8+/l+P5fD/T9f9/18vl8fw/y/wAP8f29uvX4/r/V+r+s8N7fs+H9vv8Ab7e2VH/39f8Av+X7/wB30/ns6CbsTnJjbZp4NZEDUffqgibvrgFgz5jhzefJSQox4ojEX51lwKO90Ccd2YRF5WM+vHHtmDPM44kmKS74GpaFLuK+6zCcNQIfbsOrythNohkYJpeBCITYAQhNbYC5KusYy2ozlRzwbS4clmKLrHDl4VlvE8Qm1O+VejUmkFwoVaKy1ZsoJpprGIdWYLt3rd9HN3Imoq6iFBSFImolMiaQooQoCgpE4sSpEIWYTWMJ1EG9lAPDTERM7CiSU1m6ZnbLuprKly87UsJsq6b3TveUVJpvERASUcJ2zelmoczICwm0IRRotlsiBTLbjClMTFMNCdsK7unDENhvQuDlwA2wIEygPJCcqW02KBnO++d987788b54nkTo8TrTVShSVPW2JwpQ3SZ14tlTaTpGDnr3sb2HSU6O+dcK1YmbqXG2WhQnbjriY2zhNtdc9vbs5ieIbwT2Tmmb94e5Ksu3rt3jXhrPXznjbMZvjPbfXi1o6+tp32lrNt9nznx7u3rtidu+2+03nXh29buXE39IXp8Jtb1tx23XNo9fp367l/a/NqY13+nf6RcjfXGl+J3ebYN9hyYeLS5jBkYopErDoYTHCbcNNNFJcRNrkQpodChLhooU31b3pD0uYeuL5Tb0JktMQaEY68XwrudZq+3f077ZJluaW329rZ7NYFa7Uc7Yi126SQvPHPp8+61mEPDWvs/LHCmYDjLys79hCiYc4id799d/PNt5WCcRmfn48+XOzhxe2TZc/Hhxm9NVjeNeeL7ca8XHM9eTb1JL2lYFn05nb2V+/aXD21fb6OPaeuJCaBO9o4x6a4U7w525zY53vEbdZyzHq7mO/G+I1tkMSWbRjCjYBQhpup4DQmioVb6CYr6T0igr6T7pEBRurUhoVJlo0HV1CKPR6YabQ03nDBR7plZdWaNMeJo4HWU4mUzAUcyNrCig6gDcwmjRqJcZhuk6CKZFCkTahTfORkpoqwWE1NHRzRoZoHQQ0Ojq04hN0AvSBpjCjc6YYx+40lQBUTHSXHQKN6X8BCehUB0cB7ygUaKNpsamdG2x1goNSmooEp3cqatFJE2CEUAIFM4qVE67Ye9sJ0aaE5ahzSRpxNIkmhW9CSKNoT9xMMgQDYKMIZKYwwoBlYpdsTCgxiANBoaKEwClBQUjQCBoq2mn+h1cN6CE4RTE6BLTdHL6DG5n3Mq02aQJgiFBpdtqAhorCwpoDKSoQnINp0FGJiHdOsoUOI2uRNWplOBwNuUxYYUHMJp0dJanoNPMYyhg50neHNHgKMh4hqBzCi+K5KRpMl3GGMlCdQndA8vBFS2N8KG5wgE2nCteJxKYnhjdD3uQdRgE1PBymFR6NTRj/SVZ4CEIbqyfBg6tDaGmNMQJt1aDAYKACdGxGhRtzMlZT0ZeZlSyjoAxNlSHUTZSE0wQNtAKJG3AyYFAITRCvNx0KNMaJ8IaamjHoxAUaaHIxiEMmgUdITTG72ta17RaDbta0EJtcRlZ19W0aTObqZvKApm3COF4/VXq9e/p9PLe3l9r/j7UJ69/L27ev4/PWPYhHHpK+fjt7cijOaT13+1uPp6/htzHiRTbfXGv3/1z7eL5877x14x8P3+a+/49e/1erd/n19u+38P2bfL4b8Z1319fL9vw/d8O/wB/r8vT6KXr3+Pt23n7ePO/l6uJ1xHb5+Xx/D5eKvTe3Hp9fH2+Wf2/x/hv8u641ne3Jf78Wx/v2wsLXnXvtxv2PP18spqyxbGDx+N8W0cSPPlzPHXKiaiL4ktjJETdQ0ceQOSooTUYzdw00Uam9HQjSJtje8uj6OHOzJoVjHXOvMxnFtJ7bxO2IwrZTRiMZvFod8q7VpscduPTNpiMwdZvjutmNYWrNefS3tvMxhWb3jHzf5Q87YIo9db65v139MyswzXjJjF+TOrMXzc8+O0b+f2+Mq++07Lr89/h9/Ldod7K6tv7Y17+kq6zbfZX4+X19O/akX1Weq231fPpjeHmeFrGvMflvnbMGfHjaC2OI8dbYwuvz7/Kxb1+f09uL+WG+evWmu1nxxvbbM+WrZfXUU77ivkazzvvvvnjfnnON+eGIBXUbLICKE273O9u2E06OMdpx1nFzQsjIcRGc6FSLu3C8ikEKOrzf18vb7UIU7LmLj+n4+mRzJzsKcW1eMp2gW5Gdp25tA++EK2donONsKVMopG6xZxKxuil+Ox5ze0S0J0/Lvz8/PhjWETeOba9t4EYtmLuWptGU0zUx1jbfv7b4stk7hrxysevXGFikwnd8u++kKE1h9tbUKOkTSdvHJDQmy+BY9Yd6SxXwGLbNjfRpwhgVEUtlooaQtzjYMo6SrK0t3Ok0xS7HPRy22r0bo5wLHeb5ZJNJQnq3GLigiYUdvUJvmLw0S9d7zMX2xNyIu97tA8TrdQs8zfAhtZzKfOMtzMXm2MxclRFm2rxjJS2LTxEIuRmmObYtHKlRO6cx2ndXvinflZc3w9vovMRt7YgIiONdgnu9azZuz3Lz1ac0GBTe8EoeGnhxinDTZbXW8Ti8LXu/eJ+B0ZQ0H4CfR1ECbGno2m6CJfgIUVHoKE8zQBNNCE0Nul2OLajTBjw6TcTacEnCB5kKOrTQobad5YWFLTiKvEtzTFJCgoiXEUgh0HGE4cThAomE+FdYve7bm902rEgMiZWJpGN8y4vSFhyoUS5emHAr67bWxmQCATxlq7lqBH6DwCooR0afveh0dITR7oY/e6lZqVY0+hQQxt1aDR1aZR6BDQ4YIZQc0PBtxKGhlRo6CdZETDExBQdGwdQYDKMY40CLp6A6lHRw6sIoVcUaYhDgq6RRsdCaAIG5KturZpJ737n0lHSegglNoHpIn4OjbHUafviZ/QVEJlG6CmppCmWYUMlS6ES0+k0mcNQjwAm+va0sdGnJE75KQdITvjcuLNG7XV4hXUoJUK9oLUIuMdGDtfM774bITi5aclM0k2xkI7ifOZHiSQ1ave2AVkIQ1KyUbiROakTAPM0LQyXEyosxN/pKvQQisdCgDq3o026ng6gz+4oyo9DRt0NBoq/BjoJvwAcCu9GS3MibTUaECadR0abbdDo0MEJtOKuRwDQDUTF0UmrKuWS2nSU6EjZQBMcA7slENCHRpjhg71iYTTEYlDKRWUyMMqCBNPM7hpJ/6YAhQEAAgEBBAMHBwwUExEOBwAAs7UBAgMEsrYFBgcICQoLDLG3DQ4PEBETaRIUFRYXGBkcIWqwuBobHR4fICIjJCYnKSorLC0vODu5JSgwMjM0Njc5PD0+P0JEUmOurzE1QENFSElKS1BRVFdYWVy6LjpBR0xNT1VWWl1eYWJkqaqtu7y9/6MAAwGHYbnkOrsPEYaGpcs3GJClaQsxgbOrlGEY7CNgsWBY0pYYlMHQhZuQjWSZYQgaOYxgU9Iord1VhM0WQrNMRG2YZouNFBTGFsjRoQLEdhdHsZl6nublGrq02fU0WLNI02dzDiDwQ0SgoSG9sU8ilsR0IbynRgmmI0TMLsAKSxQlG4jBHGhoFGrC5oWSB4iGjTTY0Y6upEo6mncnFYNkuxYRuLY0ImCBTGESBAzc1Gc8sEoJjAYjCm2KCiiZtiJRZhHTMIKESGXMyDYzjOLFijK6FBASm6U4uGNsi0MYwopjM0PyO49BwdU6mEbuzZ6mzGjYpsN2goo6gsWeJG7SRhcobDGNiCUWcJsLYglm7TZh1K2LNhPhIe+6PmOQG5bvidHUs71pbMOp1aVu6lhs6PA4MepBdWFNmLSw0dix1FGjHiXd7q0WOw607D879bq0WdzR1EOLxfI9x8b6H9ZvXqKHqO96hTtLlgs0b2zTS03WnQ0aY7ldGBFuxu0tixYo0I0aNEYhYgQDgViObMLFNnc3MR8z5X+c7TZ0POcmz4nzux3nifjeTuHY947TxjsOp52x6GEYWOByELEE1Gi7Ypi0XW5C7uIUXdWmMHU0IIQouMdHCZBjClEiU00BTZKIamrTCiimEbG4NQ7l+QfmPI6NjtOCLBhvxHtYOjZjyCxZo0OGaEiLCxqw0KbNm72tn0Gj3JuNc7wueR2eKbG5u2YXaYFJokaKDUiRhq0wYMViU3WiJZDQpvjRCI0wp52IZI4hDJGmgMwsjEi3YlJTM6ZWDq2IRxfDWbYNGhcFYzlsfCY3OruPEdbuKChhTo6NiB7g2LLRG7G7TqbPIoi2KSiMI7NncRs6tgoad5TTHVYwsbBo+DSHa095xe54NiG5sb3Yh1m9o7A4LBjCOrQUatyx5HVIdTZXQ8Hg4nwH0nnNz5De/wDR+F85wdGjY0Ox1NG49gcGPjCOhs8Sg0NxYjcgGhTA4LTo0xsBHrdQ3C7iMI00bL2kf8XV7ijinkOs70uOpZsWLm8eTZ0dHUjc7je3eJcubER0LvAd+Ofsxz588c8c/Zz5455YqxydMxhfDbp/HLuxbDzxoUkDGcxthIlE5mhMRwvP73m4gc8n8k/2xj/bndzhTp7H+IzGMJOcQ/j/ABOcyQnNwZ6e3+XtOcZ7RhnAOZnnnGcwTEIA5KJzfvei2Montns9n8s0WxDH/wCfy/8A32/fzmSxmsPP/wCj7+iKhkr/AOf4iYpwZAOiRgwps/7exxbFkhz9jOlkC+TVYQt9+MwCOhYNhmNG7zyZyOaNMlYZg0XLHGhZYLkg51CZrnXPLHOY0rWfvp6GTn0TDfnGE6Yx0hmmGB5kyRTp7Jz9jn2+3OKOftnT2lsezAvsy4LewM9OmJ7c9MuCZZz+8U6dEx7IJ/HGcD0zCno+3/8AsTnPaUY6M54+/OH2dD2QxlDpnpkxhowiYyYc9FhQz2pgxZswxAM4LHMIGWGSOcucuc56Zc5y65EGNGrZ34yMxE0LGSZG4JRHnl/lTRlrLnDnN3oRnNzj2C0GKMvsyuIEFx0efPo0zNZJnHRJmMwxw4z7WCmiM/8AvnRSRw4x0+/plYucJAn3xwRhnGcZzOeMwsQ0zzyaFDzhnCw0Y4WOqQgxoMXaS4jBhDDc3PBgJHcxp5FES7ZooHVrm2Uvkx06KIBiFdI4pg3xOYe052IuT2GehzcYxizTz58+kY85ks5ntxMgI25rPYOJlmc4z0mYwMwpf5GLNFC9OnTJYiUgfxOhMsxAKGJCOCCsJzYuCxiLTYsGBWExorCnMywKDR1CzGYbOpZEhqwUI6mpsYQLhQQmBIFDgpYUFAosxBcUWGmEzmYJ7ayWYuNAwtNsLMBz5xsLlzOefb7c2YMHCez+WC2GBT09v30DPbnBPbOfsCYxl+9MTphhlzAMzGY4z0cUdMTJ0gR55o55EY0zBM4dApjiF2ujBKY1iOhciXaYWNGjV0KR3liNHYWLlmFmARs00YmJgSJCMyXNVCJZ2SDCmw0mxbKkSYsLkCGbkNQjRBgjGyxIUzFkoRIQce3nTC/SGR6OebFcJGYxg6c8idClUrOKMXxjBzViIw2epORTRwEhBu0LCzdocBF1SJGLdEIsNCDhosCzBQRSEKayHSiMG2GGMXFGIOVocxgdExcQo9mIuaXFMy5VKVuuIxspBmc+zNC+wdFZzJiOhCLgWFGhFhuLqFseZ1O9I9R1sOsXUjEbOoBGzcrDQ2SEG2aY3IMbrqEcXLLcouWKwF2FmzM2abNGbohGEIdIQu6PMi1nYijWFsrZpmGghuaxz5+znz58+eOfPnz9nOOzFjvIxN6WdxTCEdSYogxsMQyQI2YsbK6pEJmJRbFYyEzWIQoXG4mazM0MWhFWJcYWDEWEIzI5YMW+LOYlNI2aSm+SgIMbtFhY6CTKOwXIbiz3O9bPDMIDsDBg7CwKNCYS2WZKyrMFPSdL56TApgg00wToDi5htlOdgGYFLOaBSYhRz9nMoYwzFAhMDWMxmKBmM3ILYxBKFjZGN84utYjWVmYRgRmOlgpbGOcyzFEVQOLRWI106dOnTp06dPb06dOnToAEIFym4jDPBomd4U0UatFBZ4upG2KDQmbgGqtjQsNERYMNc0RNGi7BpudOJCPQhTuY6thxBNh0IwYRu8CmHW5TqKeT75wKex62+NxRQOqtZBY3bLHgEYRKLBZhHZCI5xgpCyzFLTuVG6l8Bs6ZuF2EQIFyzRsuuWzQQHty6lBB1IuhHsbi9xvdBIPA1NSGbmwMGF2LTgoKIiUFIMxGYrLTGDGiIDEChgwbtIo00xY0WL4mR0S46ZmdcRaIsRho2zG2Fu4ehGOhQ2GEYFNgjSXDJbLRDet04vmKODHkEBgUXDp7M6KRrARHRoSDGiLHnCDGFDlYQbELFywI1lEojBocmQ2BWiDbK0OEo0GDHQptgzRZ0YEwkczJdj7C+LFsQaNCNmmghdjdx3voOI0cSJRwQOTCELFC0cSNmzoU3bpCyWWCN2wFyMXcPBI6lmCR2aGGwUptjN0dksvBI5jZs+I+x6mZ6mZ4kIUx1ZnqI5p2yDGgRhAxHVgtMIbBCA2CyjEdCyrGyMKbJHVuwzBmSBZGwsUI4YwdTJRmZHEKYpRZ0aOAmpZ1KaO4PCPPzj+Q8IFfBmbn7in7E9D+xfBmbn7in5Hgn8z3h87YjH9DwfyHqPdNTcdZD0ieZ+d3kO987+p8h9bR9x1vB6z3nU9D5k4ve+h+J2PE+h7i7c3lzqPQnWfKcTi+I5HAs+MdTZhc5NPe007NJsb3sOD2FyDuaNzRHcbOjqWImr406m42Y/MeUpp85wbJ5DxnIuUajwGG5/Cdb77qeVj5XtTUepp+wSiDwODwdmJslOrE0dzudx5iyeZ0fQaugmg+c5JoaHe7BwbGpoRh4jV7nrSyP1mxuLkNTZ3tJskadDiavlYMKO4j1OjR3G92IaPEdz2EbNnUhduQsR1PcTZukYe+cjgRgNL5CnYo8Zhs7z0DZ6xojc7mHA7yFmPI3twu0UavYava8iiLqcAfedjc3NjsSPFphcodR350I3DUs6G8TRsdTRyNXcWNB4O8po0fcKaLvE9wp3ly7Rve5d71tmz1sNC5o6FFmx5nUo4F25RoQu3f7nZpHg3Yd51m4slmInYXNSk5JqN2PYWOJT1tzZGNEe8uw1bFLsMYxeppsjRd4kHZPEdqaO50E0PgfeSw7jvYxx2GxsbyPUedHeQs2Hebl8pToQiO92SFjVYbB2vaxp5Lde0uxC56nxDGHiKfGx8R2v4XR7GPyvoTtCHFs6NmO97/AP+jAAMBeD+R8Hc/pOC+DoWX7i5/APsPmY/7yy/cXP4B9h8z5Dc/vf8AU7nxv4j+p+c3n9R/UHuu56j/AInvHyPwkfiPuOJ6H4D7n/qcQ+x9L9BY0f2v1n+T9D4nvdmHJucHgb38Tyf+b/3fO72x9zH9zqe6cG7Dk8ncdr3L4z6X33xm50N5dh5ze6tne6m4sdq+8/lfQ/lDR4P4D3i5Fsd5qf8AY2Y+lseo+p/4HU6l38xZj8Jwd7+h992fGcS55ngUe6cT+Z4BvOJ6SPce+dz3mj8Zcp/9P1HxOx4NJufjPM/Y/CaHlPBpXsPedzTH0lz8puI8H/Uj8h437X8B/wCT4nynjPjPtD1gdqesBv31gOa+h631gTeesBcH1gIefnPCnPWAiD6wLpf73wrX1gi6eFu7z7T/AOHQ/cPaeDieDsfuHtPBxPCyP7H7H9RT/wAnwpw/rbP4D/Q/zYf5PU+4+6/Sfif3sfgPidXwaHV/EHEj1h7pqf6PofKw+N4Nn9LyO83H6nuP8nY7HyGjwP2tjyHkdx5T6Cxq7n4HR3Gh/A5BsU/Ke89x4g7guR4Gp1H0OjufQbH4nqPgT4T5z3z7Gz3Gh2nmfKeYsfOdpxKdA+EoNjtI7jkwos/GWeJq/wA79xHk6G5o9J+c8rT8R+ss9z/odhyPfes/zPdeD5X0Fl7n8L+N+o63ccTuKfU2PmPtPlOJR/gdjyP7Xyn6z9h9bq+Rj6wVNfCRfCLOw9YD8PhVH2va+sBWHwoH1gOEep8M99YCLvrAc4/wfWBah4bT6wGTMYxjGMYxjGMYDBjGDGAxgxjGMYxjGMGMYxjGDGDGMYMGMBoep9JY/S/qPfD+l3PymxZ4H0lG83v5UbtKPUd4FLQRWlYYDsfnbtn5TYs8D6Sjeb38qN2lHqO8hdsbLDY98o1dHY4HuFFizq2aF+QbJTq6OpGix8A7i4UcjyHUQ0aB1LkbvjdW7YKdSjRj6HV0IOhxFWD3PaOw06t2yxewOJD0lPmKTc6kH0mpDUs2bFhOLoO41KLmiEOBBdgPK3LO5updLFil9BRCim5qUoWdDyMALtIMI9bvDtKNW5uIEN2IU0cixc1EClIkFd4xgQ1LJTCmnRC7uYm54ps3d6DZutMI7OjxLm8sw2UjCk0KYRhsNMets0wbrQRohc7DvSiERpjTTR8LHYjQaMwGhBNDQpo3EHcR3tFBwdQo0LugJGzoGgB2FzR2YO4ad6tO9E3m8p2GFmgVNSMdGlgjuHYNiwQiwsBsUWOBqBowodliWF3MCzGwxpu2SjRjoal2xolOjYSOiQ0bMbFi4O9sxhGENCmzTF6inZjG5Rd0aNCnRi8AhddXcOhdoe13HAsUPekdhYoUbyFCWyaOjBswjxNneNNxuxsN2iAMNVjuEdzsR1NGiNiNxY2e5Lt00bl2FlYLDsLPBjxb4CliXAoeTxdCNykhGkuQ85cu6l2GrF1Ye8jTQ2WGpvA0dHQ2NHcwivJooeDZsO9hxabsaCyO8uxSNJTZ1IahCEcBHQIcmzZswYWdxEKaBbO90KXc8G5CLGgKaeJci6I0URs2QgjRRGmji2Ci7s0WC46MYWaOt1NAu0lOpRZaKSl6iHJojRdXRaLFO9Nsci7EpsKsGzcd7yLmoQjGBo0Nh8bwSw2LO8pLNjrSl3NJZ2bBCNJTxaNDcl0RCimzDYhR5TZGMaHc9bwIXNC5CDZ0YRdW5Y6jU7lBWwaHaQo6nRjSmjRRZj3vESmNG4IbPA3FnyPyF3Vu6MbjCAPpDtO5E8xR514PlfcY2aC7HcOrvfOsdB9wudZRZoh5Sm75Gj1PuN3ecX0HYxi7jc/jfhOw3npHcjT2Nl6n+s8Ht8J891sfvP2nWcX+x+Q91sfvP2nWcX4j9Zcjs/S95wLv1H1vW+Q+B3Dcp5HyEO87jxtGp4j4Xe/Wam5ps+M9DDeXfEeojofKdT1Jq/ANyEdzyPgPIfKcD6TY3v1G4+ppjTsdhs7EdnrNV7F8b1O86yG55O94HeR95j2BcuiUw3nztKUkdnePvlmLZ6w4u95F3QjTs9hq7nR4Gh3HcQ3JuY7PqY9SasfO2PUb01PibsLn0GpvbnpdmjixdGx9T2sOB5mOr1GrQ8jg6PUw1NB0GjU3nies63gbnsKe47yPB4ronFpdR1GjvNB+R0OIlmmyOxYjds9a7PUXKfS08HUu6FmJ2njYcXQg7HJs6HU2Bu6ELtHI87CnRjcpLGr2O92PlHZ2bm4e1eJ5DrfU9TYs3LPUe+m5sm4u7OzZ73Q7HgtN2mNzeXVu9hwbHjPG2GjewR/C6vW6vW0XNw6MYRo7HuIR6275HrPcO8svWR3m4p6i5obzTCaNzvbMO8s9abgTiwu8jqNWnyvU00dzo6tjUidi8HY/M6nB7HQ5HuljikV5LZu7FjRo7DvN7uaPKfgabvzB2viaPIuy9r8xQdb5j5j6H5D/AFdXQs/G5znOcuc5zlznOc5yucuc5znOc5znOc5znOc5c5znOXOc5znOXQLn1EPWA17+Z9YCEP5nwgT9p/cw+x8I4/oP6Sj87R4NRd7T7TR+R7mOj9R42PzP7XrP8TY3j2Hxn2nW+8/EeN/Ycj5nxP6X9bQfGcl7T8Y8n3DxnAj3Pc8n6j4Hztzg+d8HV7F872G8LvyPlfidDrKKPrOB2nY975jsPgbH5TcRpj4Mp2MOJ9RGBTdj4WjZs+p8T9ycTV8T4j0vYeJ2eJ7x5Di7Oj1HnNT+hsfoYdbc6yj4H1PodWn9g/nPCYdxyOw/S/Sbz5z0v9D6jV9x/wDZ5m74YB6wQ7PWA1D8x4VL9R8J+Q+42fC5TwsTqPK/jPBoP/B8B+t8Ik7z+94O48zvfMfE954Mp6wEHfmP0vWfwf7XuPtO97TR8JF/AfvfDAfDafdPK0fQcXkfSf7mje/Wb39DvPU/Qdh+A7X9B9r7j2H4XzHrAac8L58JH/+h
      </FingerprintImage>

      <FingerprintTemplate />

      <AlgorithmVendor>NA</AlgorithmVendor>

      <AlgorithmVersion>1</AlgorithmVersion>

      </FingerData>

      <FingerData>

      <FingerInfo>RightThumbPrint</FingerInfo>

      <FingerReason>Not Applicable</FingerReason>

      <SupervisorName>001788488</SupervisorName>

      <NFIQ />

      <WSQImageCompressionRatio />

      <FingerprintImage>/6D/qAAM0EpgBSAPYAXgAf+kADoJBwAJMtMlzQAK4PMZmgEKQe/xmgELjidkzQAL4XmjMwAJLv9WAAEK+TPTMwEL8ochmgAKJnfaM/+lAYUCACwDLw0DOHYDLw0DOHYDLw0DOHYDLw0DOHYDN7IDQtUDNzoDQkYDOSsDRJkDPFkDSGsDPmcDSuIDO3wDR2EDQHYDTVoDNVEDP/sDNGIDPtwDNC4DPp4DL/YDOY4DOxMDRuQDRKcDUmEDOHsDQ8cDRjoDVEYDRasDU5oDSYEDWDUDR3ADVboDS2wDWoEDSpMDWX0DVIMDZWoDTzwDXxUDUYEDYc4DTBADW0YDUpsDYyADT3QDX1gDT2UDX0YDV/8DaZgDWEkDafEDT1cDXzYDWG8Dah8DPOsDSRoDOhEDRa4DT0wDXygDRokDVKQDRpADVK0DTtsDXqADTk4DXfcDVEEDZRoDU3IDZCIDUioDYpkDXw4DchADWzwDbXsDVPEDZe4DUyYDY8cDYxsDdu0DYPgDdF0DYpUDdk0DUOYDYRQDh1cDomkDYYEDdQIDsOUD1EYDWlMDbGQDYuUDdq0DqesDy+cD81ACHTMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD/ogARAP8B4AFAAk6lBD1xAajr/6YAmwAAAAIEBgkICwsaGhYLAAAAs7UBsbK2Aq+wt7i5AwQFBq2uuru8BwioqaqrrL0JCgulp76/wMHDxAwNEWadoKGjpsLFDg8QEhNlkpiam5yen6KkxsfIycrLzM/Q0tQUFmxyhIeIiouNjpCRk5SXmc3O09bY2t3h5hUXGCpvdHeAhomMj5XR1dnb3Ojr+f3X3+Tp6u3u8fLz+v+jAAMA/f6MPzfi/Nz/AC/7f7/wf2/vfg/F7PX+3+H+WHk9j+77/wCd/wDP9PccPe/B938sfq/X1dfbv9j+38nj+n93z+f6u3x/e+7/AEfo/wBPo+f9/wD0X7nhbPt/11/Z9H8P+3o+14WTwpvsYf5/X/H/AH6/CreFz8K393Z/1/1/2/8ALeFu8LT4Wb+ro/7/AMf/AB/72ex9rwq/20/+/wDr/wCfx8X9/s+FM/p83/P/AB/x/r5PF+L+z7m310/103/n93uePb7f5W9dP9dR9dP/AP3+nHq+XL6yjgpi01aQIIrEkqYA5dPCdhCB2RyhQEGhhKfieTM4A+nxj42Djrfbv83WqE+2s+OXxlBp5pY72/cA3w7OzEbv1IG2KcTu/YjU9wDNJ/UzZ+71aMg/UYK0qDf8TzLBGZnDIIFDTIPezBHtASaFCy0QTKGOmeGQsaqVywt3+TrWuT2HPd723jAN566B1trjJacEJpOnP01xgejbHPThEkDdk6SxZWTp/f8At+f9nc9LcJusyCLGbBCbAZiAsDlWgIaOjMgfDHqpjYZV4Yv0hA7bhkgtl0+/l6N4L4V8qDRyh4fj6qzjSAdN9dNmEKY1jt86cEAkCcM3cEUyYab4AIEECSgtIQ8gmChg7MguBmLAUlRntI1g0U6zaKIRAd4UKNcOQlCD4A3eJNgQCBNxOCPYKOh1B6FBAcmCunPTEoLTaG6uqmeXCQNhtBn0qVyGMaazlVeFTmk36wYGA80k4xrnRaR0Q3BJN1+SOO2OfHqQXr8Pm31yM8uMqoLQmzg2mmEqVzpYBY9Mtldu7TdgWLXCu9lwVWpQSIQiEwVXZjVGm2EwgsG7jmqDpObN5kFoOQXBKR4DGsexDY27FxPHjJA7SmbBSnUjUokaRnjh2oYBynGUadaTaL00uCqE6spHFpTaZuJmjMhGgzcIOSjI2ooUZwhg6MTaEBRiYPRAGg4KC0wbUxgC9ova8chE/ILjyi0oXPplCgGo8gCwFgeT3UCC8KYyKAB0a58i/B5PaNQ0c6TxjQCwobHFULvXIwGp8dqzdd8nQi6eXjjFqTlgKEm4pvWvlZso5shuDtWPZ0YHOlcsQLq4adCdezJqbJIADZjGWLeStczlNHg1m2taDtd/j4B3gChnx39ZG3aj/JjIwCA4U3du3jpHZGOcQBYsjvTzbFjSpw4gwCOgxxOmHDJeO3S4adMahes5T7I1NxbzhxpRKHLGZ19WAwnFctk+Nb3mUphitUamCAQJKHKjshetXEWUMFZY4ykspMoFoR0JQkG4GgQoYFA0BZOkBcLhYqmAsKFBYITPpDpdhAIO+UEB3hcYHWbzY95o4QwUIby686lCQATdSr6bhg0BAIbVnOGmTyNgtKYgRWVJzsNwgvY1S3leBIt009Hc5ZFQqYCwz2GS0z4gSOphHtQYJlCOOoId8sXqioZi0oS89+ySGJdXsMM6SfPesgfMgdDApOidcjwq4ziYGAmOjqLhJ70y4TBtwomPRz9hZp458L8xtXppJGDvxwuWaDDa3CAXtAuPDHypRdErLOchccppTtmmZr1cA19csk39yaNQYKDqKHsicWABCG8FrChOprQUI1hkNuCE2koEFzGBtYWC8G90JQc1HDepQggH0wqDwG46j4J04ECyesIsZs78w3MUWSNAa2nTh1hZKEGtS8WDVSWskzWnAkTmyG0rhji6GUjOKAXMiriFdpvSWo8VyyqzNIxsNh3Q2u+eO1sgLzLOaYqjqruwuaYk2Wc8nYCwoUagR4rN4nGRuG5FKy3lWE3NwwPTvKyQTBWVyqxoAGZSxJsGQXYLYqUlK6dFocMlZi5VrgqkUMA6yyne7ZMIPjN5NysLAChtGoGwchFqrA3hAhsBKG0QKGw2jW3fK2lD3lQQKD0lH8zam9VYsTAlDqCmizXWLAAaZKYCwWiexBGaTe42FplcZqpmAUNxmwojTIJvE4skopiGRtQrOihgGyWY1Mk2pudpyIY3SG1cw02VANSllKPJKklBdQTocOuUIsGsCMphXKYyAQXtDCq1FGIYC4Yrihac3Jc2lKM2/B1GNUci58ZCOWNELyLm4qhIM4UFGF5UVkqViKCYN7OzpMMY1CDkFofkKFAJ6wICAsraIO9gsCDkf0gSiwHeHGiH1n9YwPpm5RfGTIbAgQ2lzs8qSQwCMLs6TWk0PfwXHfOdh1F2xCSrQuIG96b+OjSkk2gLXpksAXqoJFzgtKbs83Q3lWTFgjK0HdBaUA4JGDtJBcVo/Ur8ASwNggc+OPVlVChihuBnScaFFi9IC7LJZBNC0osqAGDR7aRZquClBO+lNsXri1DSs7QgbgoUOEMdGbUr4uVMpV68pXGuU+BE0Jy6St9eOPPvSjjLPOLajLHElGZ3KC8XiAQ95yg9RzAGBCDkF5a48oQQPKITiBAjvlH9YnvH1Qg9Mh1i5geQlGouQ75qAkSEPKXR1M1PIUclHiS8CbCxcsQ1HIQoLDJHVloXk+sZHobgwpOLhUFprSSSRYUcahPGspyC2CwWlscFhkzLabAxKOyVSguKHehSrTRdEoGAgHosw1IoxYNaYKjTXBmIQahGe6rSebiMtTSVAhXEqsZ3hlBZ0ZDSL6gz0FwgLzBrAtQUeB1G0HmFh5iTYJrYNReBg/KGbUYBI3FBzUtdzygWGAHqg6zeCDrd8SbaBxcUaO20mBufKUq+8HcWm4JohqjO3KtMZtkV4V5AIyonXvbOQsIhTHtXDPDo63iBqjOqYYr3Cvy9awFgrimI49MvF7f5efXGWGg+Jpr8f0IbymUMcc8/R7nle02SppuSmwZ/TwiLSVo5lx9rjs/Hw/VG9tMOwO6D5Pr91uNwdp7K4dnkls4fV7tNUQX8+3u+X6fPt8+4XSM+vDtdfH+jIcZX4tPBI8einb0ZtI2icQuVeiuHCqBgbWTGid3Ds0Q5RIvKAznPKDwZmAtDBA0BeA6FDAFBrCCwMdRCG8DlCG82zQWDvsH8AQ/ZAPI5vMCLSBEMLGVALQBt5+fg0DBhdpplHD4vmcGBQXY7ujds9mPxRECbTOR+XPZTDo84gTaF03eV57dEalht7JeXjISyaUygv26cRJukqRvQXNnoq4udHylpYBA4z7g205CUp2FAk4rLoenAKxlYQAvbThj0vJK8Nj2hHf3Pj6xj0q4z35X4/C/5/E3FxHs83oW/LzHt+fd8GUaNou64J83DydH0OyT29ntUuHi9/gD7nYp2ejySytE3y06Pm0257+we1tewoM/m9GPv93W1B4ufSlhgq7fg95OkRTdhpzLjQUM0CPA2lHIQQN5sJQo/eYCw15gChQxQcgBuNpvOoWjjeBzOYCB5gYOhI+w95RrzyvWYCE8yptm2UByNj0g5BGQmwXFUi8pEcgrhu0G6Wm2aE3FOGQjhn5/b7OI1AvhEdm9Pk97BDAwD/BkaV81KSnSmvrxZNnyf4dtcpobn36eLufzfNu8qc9wgvGTirY/v0w6RcEfy6Y8d/Zv4PHhcACkXGfwfX1Z/DhA2zj8M0ZOP5OPl4aa5kT0j6Oz4PiEdTxFN3DL22r7+Q1Tc46DH41HbvqLjIx0jp0r9ecihFgR0LOJdnT0aNM62cErhNFYvcYAAo/KwKOgQIBrJsIRUB9J5kwFpQoIHUTaNYtipgT6gQOR6RQ/ZF4dkAsECBYAGdSYGBvnRXmmQQoENw3rwetfMFFgufKfZXol27zNDqlx4+5s+Tq9ri2CBGtpn5Oft/wAcN1HbDUW2d36U9sz6Qs9Taft9Hl/D07u7hlLFDc9faj+HDp31i9ARc/3/AKa+zx4qpNGEBZu+Xu/H4/n8sePlqHNoTs83j6f1+9598njVBdLZ2fFt934d02qr3jp6+fh2d3wM5lkupcPQnk56eeMdIkWBBWfv7/lWUanHPM3B56S97SmcssJ55XHbt4R03Ch5yQ1ghnkaZO0T8kOAvAVaUxnwbgHB1lGgUKCwWC4625CLBa0AYCBtNhQnvu/qjwC094+sBym9sdzITBkF7hsW7J2nUc4qOkmYsJuG6WT04YAnkNemdJoWHK0hghXFGCBDYXyXPjks2PIJDPROCvNC+pl6XCuhCK2plbCU1g7INVUcJlVHm73kMp3Yik2QHWu7YxAYgxQQEIjOlEyrOc3QX50nPTTgy1Jye4cI5hhOiPAzuXafP29IDhZ1K3T9HzaSWkHesZ6m4beiMUBnlHE3rt4TRZBhiUOt5zMCiiAvKBBaTzH7IH8ogYDvlkPgF45hAn1R3geYXuEFo5mQOIDloJh0FwvE1nFpseZxnYw7xR2eRnyshmwYor2m4PQ0Z5IUGqZlIBzMDkOQYQccpMp0kHck65lXEmBEwgsEGhWUw4RwwuBdHQIDAo9xm9UoqTAQaggKEPRS6NcBOXXGcC8GN7FIpKTBImZvBJiITabI2svY4cI45XtdkED/ADgXCsD6YawembT6Qti38hA8D2HwCBvCMIGwwN4atfTCp0b17zS0zPbkWJ5Jvz7h7uKOoHJn2dLhw1DqKTI4TjiSx10jsHdkhLxQ3g8e7TFZ0Cq4vfNC2Bxd0nA3U2LOLUEUbkwGb4SgQRrqMIl6ujsupYvxnVJq00KG0zqvlk8oTZpG4PHLu6mCwdKi+nZGUsgAlKUW4S4BRgEMyNmqVMJ0UTFSHN851kBUSEpzCG0SioisA8+Um06xrPIOQlD6RQiw/YHqido9Q+AoT6gQ2k3uPVKF0Fh1kIUY8wLMWcDvCykAUHMZyQGZKC4IACzsHgbykqqWYTA1kNKqO85ODYbI4MzujkObBY6TkryAYjkDI6TeBgLyHLOq1cgHWEKlACLDYFJQUNgDXuhUwKF4HUVySU0MAz8lWRQgcI14ImjhgWJtFskd0Ys81OslggImX5jcLP+mAI0BAAIBAQMHBAUJFhsRCw0AALO1AbICA7YEBQYHCLG3CQoLDA0OabC4DxAREhMUaq+5Gx8gISMlJicoKSorLTM2OEFPrK2uuhUWFxgZHB4iJCwuLzEyNDU5OjtASEpNULu8vxodMDc9Pj9CREVHS0xOUl++Q0ZJUVRVV1laW708U15jZKOlp6iqq8DH/6MAAwHmB1Llq8oXOp6y+VdHtPzGCs+CGjOMY5F8Rm54PQxvunqOx9WI701zanewqt+Z37jjjdjy8E+viwrseHfVVDGHbeL3tEquIaU43GmFh0wO/hQ99mF2VKe+emYXEdDG8cT08Xw6743+l3J6TBrjiuO/Fb4GuMZpvxGlJWDUGC8YY4yLYKJvU4pqOxKLeExHqWYcnI8yWfFv8Sec8x5j2cBmmrGYOwxghDrWJiw10xggVVPTBTmbVu8U04ONl3rgDwSxDIMU8ITBCxZ3wY8N0xUMizOPB3mKbVqcb4Yb3w6O+ODGOCJvjWo4sgBjUlSseDY2JxxKiW4rBniphuBvxqpC3AEDQuzBKGBtixCw+yefFzseT5GPjeP/ACMzVrWubN6zNqJVPY7yrMx0qqCNYOe5YwkOTXhxc6buJviG9DtjiYmFYR18JUqYmDjY38Jiq9OFcjKrjVt93U4mN/4PgtcauKJU3ucXL8MKFurtRarJg1Ftu3ahoFYhcSVoNFY9SSomhZwOKcKc8EY1CPY+M/5o3PaPtu1ajzrUdgIHY1d3eu/hgLYrmzvWYjTyqoW7zmh4NqoU2F4LYFuZCtiYKp1OGuIYLORYUJxOIuDRngTjFmxsWrEG7HIsTEqLTjJtRwTEahy8N5wN1g6cQDC0pvjNsoWHAYzWBUqmzHUCY94OrnjymT779o8j8ZMaYx0xjtO+zXedAtgxY5tkw2OnE3prvhyW2EZhNsYMWKhyoh3rMSuTK7++ozAbYxHGIAKaceG8pw2rZw77spsUaDQ4xZhRo8JKCBB0TexUSNZjixiwWrVYKsEg6DZwpThyLsxuXF++e6d0YhpX85GY7RjHxvlGGHoxyIPNhCMeWDAQuR1ZhMVjotYgvVcYsAtnWrUZDs4WYbPQgZNQ1xFhkchqzFQ1GybgFjlUNHngIj+A81dHM/mI+R+yeY+2ubDQOgN0Nla8VEAOoM3oY2NVYx7VxCzzSY48OITGymGzA5gE3ikdlMFNnlVZrg6C44IclKtUxejSqoJReg03794uCFb6jKi2HqAFnHHJjwxJjiGo4XEKsdWBH2j7R3M57A645nFZMeTSvYNRsdRpmMdm6QsHa+IgljricVC5HlTUpbHIsB2cDFMFc1sonMsSpUOZfF05sJiYS1ciUlmPIjSxucgTiNjsIws9HIj+d6mj+I/xNSxorUeopUrscNLN3pvZYHXeYcb4XkYnFcJauVV3wjCVHVsZ8cjDFbcQ2ws44EjZ0ZTMNYjsT0gFhHJyqwURYapYqFVDZmJXejZdcJbGIIbViqWFkdluMQ1bHgyoeEx0GxH5MeZ+I/c8nVfGDY6kwj48KAHMFsXdjCwix5Cor0TcYROdVDdmOgpiEToYwl2LqKWwLZ2bEY2a2Giyx5lQeNDMmIR4Eu64lOTDG1bsWPUyI1OOrZ/TjylfEf2vmNFPMidcUlWx1phiuDq4xiMqugTdqzyJQ2V5qscmGtQaRU2wLg3ZXMGqCMHlhsirzKBqr1rVMxGYLDpiCYcG7yQ3ahWIm2JiwkFNd8TBhIRyLFWMEIMNRGrYg/I+XfzP8z/qnlPDsMYs0vRg0J1GCTwHni2CNWdkIwrriY3RqPIMPAWcOpggTBY2YVHGS7NUkLGORlXA8mlHMcaqRgzDsLMDZOlVfEMErVahYtT03eMdpEsNn9p3PIZhyPOLh6lUHjIw8RTBYchau46BqciGlHNxZI8xCFmDyIrqZrdjdhcswlZBHVgq5DoLZxYsDmbmErEFUzScYjnRq4LYxCDDVgWA3O0/U+Z5vc7PMTxNlj2tl7UzO0hd5sUOwWl7CMfExGz2YhxWbsoELDsAwiPMgQBOZoPNjERWxyqFsQY6DEs5BqRmLHkRD+9zryjq+Q8z/icz1hquwEMSupjDB6mOGwdlUYLvOrBd6IUL0Kqt7gw1KpxRCPJmOJXGIc2hZRKjqVZLkLGlJG6Nau9Shsx2oxhKxEjriBYC+NmFqsStm2IWMjk3P869Z7mV6PnPEQfGrCHYJB7TIeolhhyBjCDY2dwh4uKswjzcjsIWxkbYWzYs7VC9YjDYYwsEeRo9DN8g5PUzYc11fWY/bPK8x877a+JftmgnkeMZBiG3B4Yrs8GG9YrqerecY78VY14qE3OO/p9OLfV4d/0fXY0Zu8Yx6f4G/Ku/fff6/T/44fVXGvh3+GJ/H/8AH+Xfvs/V4fV4Rf8A3+v/AG4ci1erwMcV/H/bwqoGdRMVx/8AXf8AX6jGoE4x9P8AH6N7Ua1iBMfy8N8bd+N4T1fT9PfittyU0+H/AI4A0xRZZ/8Af1Qm8c13cP8At6v4UhqATwx/C/1nJWceG8WOx8L8J53326+U1YGyaE4G9BsFLT2EPV9Zv1xf6PoxxTz/AI/XPSfXPSFzP1H0fVj65343dsd/04//AHFPhTy+jj+P+3014fWyuNT+G/8AD6f/AI/l9X8DGNuPT9X/APfR/wDP8u9hmtvSeB9PfCHqga8fV6ePVvjwrw9RrvDwt/G3fO+Gb/LH019fH0eFg1d69X8N+/vlcVVaH8ePSer0sNw0FAoeK4j4aY4fqePpgYnDq3PD0/w34qMNK3HeVh8T7o/9H85ox2GHlLPQMMw9hAQDpgsM4qulOKZXDyxMNYlYwmxVzG9t+TFQXjqwjH6kNalJj659aGgNYGz9HHMuPGPD0uorjG5j6XkuI1jj1eG/hWhutTHePp42YiVBtXVs3OrGA+IH5X4jzv7QyepByelVOHrvYJ3pzbcYMY748qcVWCMwavG9TFWQ2rvmMNPDDavC3e74rBjbHeTiKQ2d3jjc3m++A0rjG+73s4odHHprh7+LHAaG/FUeAQPrNF7z1cVbG9d5oY4m7hmPUzGlUTHfKleBtxxxieEd56ajpUZRiO9HhyAoZhhzWMc3Y8pch5K/WH+q5kNEX07nZjiNYY9N9633YXdcYcY344HkTwlUL1rvmMVhxjatx8OI44xXPD9fgWHm7+Hq33MYuWMt3gMEAdCYbEeyrYKKp5FqBVg6o4N7EquMzjBwcMXfjw0KJwsCEa0cTibxm+KHQhDGI+Ep6Vcsescj/TH3D3z7iwyexrHiYPi4DwsNzRsEbHIm4gq2dR3heo7YhBZV3Vrid/ExB6JG1LkZEDEWlhmNAweDHNJQ2DlWIYFbY5Nh3vXFaMd6tiBB1YMIER0acNSiYm5rRKSMa5gJBx7R8z77+YPIvHGrqErv7AxHCL0QLD1McbuCGzWITDd7NyDxyDE3jGFbYlRQsGwWwBdhpVEKYw6bhBbO1Y4bEQrVtVyMXUIwYOAdMcKpeqwaK1uhixvrVbxICR5OGUlj9r8x9h/MmZ2J4249UjBo7FSL2MJg51iYmGxzWLm8mb0ketQd5T1TCxhDkLMQbMNSEPMJd2LFhSG1NQu3NcHHG6Jd0VKs3xyLo2xDZsxDGDyn4Dyh/O/ff9TxtiB2MLEe1upz3ulWrmSrDO82YBZbJsJKGuF51YGvB5Nlw72xyYxQZWxZGb8TFHJLJ4cdrhZhHZyMRlc2YMK1sjZWseWsjmwZWPGvdtgdpcfJVYfHRMHPDExGGOQ2OKOOHbAxiR6kVxghscSrGHDyFCAY5MLYd8QDZWiVYNkDTHICpiiVE0ZQ5PfA2KLMYmhYq7UxyWDxBQjswuIPMyP0vle6gHyp5HyEqz2ubDoWVg8zMhXNjEh0GEJR1M8K9CxCh5MYRXqWbHibLB6NhO1snV0bHnOx+c7qF8bd8xY6sGw8wFIdGwEOxsZY6uW/VgWpo6NwIPIi0DE6EQQ5BcgBybEbN3Ui2AV2bp4j7KQ7X4DzHxP/AKHmFfE2w9jcA64hEeqytDamzFCGxhbHYN2oPPEKiPRSF2Y5MXDhs42S2DCQ54swegYjdSuxGLZ0SyRs8sMUuc1sVlg6hc8QR9sP1n/R0eTzx56rtbYLHRjgudGGKgx2GNTBHmFjLHXBVnrwl16MBCxzS2IwDmWESuaVlXXghKbVzCVmcy5ZYGqxahc6jZbuoFhth6ub/S91me6RYeI8oF3kxLr2jiwPYRY8hWLCHaHaXYMehasn7xZhfHmewu+u6N3se7wY+NsJ4mx2uR2BdOpHC3OSRze0xHtYnibN3oWYPVmLvaRhd6Nxg+IzdhbJ41YQ5tg8z6AGOO6uO6Nfnx6AKYPnfQBvB6AFUO5tLvzn7z51IR+2/GL9w/GZCwTtfyPIP1tzRh+s1IYg3bP9JDmmj+kjA5MLlNz4zxYskT9C2djmn6q0aV1H5ByVsmY5J/SkYQg2LObmfiOa6sYFkS58bbA2Sw2HV/oNi49jMflGzmcmELHympmQsjk/kW71Mi7YyPwpGzYjHkw/IYLulXf7WUjDRbDcRTJ952YFnsYbD7hZjGAwsQs3rN1GPtqRsRqrNl6Mdj23VabBTzCMM34TMxdiZsNVbjY9siRhdhcimp8aRBuVZ5pHJsfASroJZdCGafnbF2FgTQ855DtYXIl2DkZOZoavrgN2FnkwsN38KWIxGIjZuWIx/KxTJybFzMu6kT2yxekyNDNbpZ+F1NmzAY8y57yZsQycyx9k++xtSNh1PKe0Xcls5D5GPuFnQjYyM2x1YOp6yXMzqZObmWPbINyxY0c0Mw/GTGqWLOYvR95sQcnJjk5j8JmaDqao5vvtxsERjZFg2Owu+0ZJi5HMsx6mTY9kjcsQyNHtT3S4aMHk/oS5GN3R5mTHJPZMhuRI1dM0hyIv4RNFMsed++RIFixcMgOh0fYI5uRTYhZewu+6WbFxsalx7T743bkcy5GxzdEjH2i5d0Y+Y0H7qZiZGTHYI8mCffGBdybOZ9hPZc2wljkZDZ7H7zzbEdh8z7A3bg5rmeRLVGz98h2BoZF3JuMPvOrYhs2TkWdEX7xsxjEzI+QZWT7CkbtiMbtx8p7BZukdQjZI6ObHI9hsZMDmWbGZHRs+82SEXR1TVyM38A5Oh5EzPeG42LN3tLH4Rycmw3e1zT3iELvjdSP41hm+NMj9qXfzvoAbX/+jAAMB9AC5L3f53RQegCDDudT7J+59ADWH7X0AWs47nIP2N35z9zkw91/Av+DkWAsXfM+yeIuf8FyLP6DVywtiH9Tdu3LhZh8jFhqXM3I/QwOh+kIVHIOYfKZYbFlbVyfzmY81c27+fCReh+khmWXY/MtjsC5HIzNX2jJs2fG5H5DJ6OxF/GsLmbkXXIPzq7Lc8Z+EMnLCxY/pIws5K3Nj42NzNfOXo95ssOrK5vxBCYYF1yI5PICy+4w0bOZGzqGhH2wL1GMPOeI9kLGZ2LAUuR98NFuOZ+gLOWHk4/UQsuLvQzLMcw9sos8qLJHY/G5kVmIR2Do+d+yBkWbGZALqsqzAH3HNsEK6BZ+NY5lgMlY9D4mEORAyLtzJfcxk5hkWf6iq5GeIHNVX4C9bhDQM3Ns6MX3gLAZGZHZV+FwXM1uBsq5L7zUbGZd2XsC1Htk4LOMcsXdA0fgosDyByVTYfwvMMiEcnqvrugLHk8iNj4HJblhw2Yua9GAe2uTk3ALnmLHrsrIbmWG4QutjINUPacksw5naQ9ws2NjqWOgewwuAapfDo3ItnQPvOS4bpEsui9W575YI5KthdAhzfaJiU9QfGw1X3V2Ku6IGh7oXcyyZkYcgzVfXZjkvJe0uZH3hyrZW50bmz7JZjZs3WEcmUaOT8DcsB/OvthsXOpYAj2P3VjDI0LhZj1NA9dstirNl1V+wXf53IIpm6t27mvQ99zdKHyF310sXCEcWbMLkYFjM2D7o6OTHkBqR5HrlguZrZsZOTZzdT3GwZurzeT99ebZdHY1YWD8BzI2G+OQWLLci+wFnm5hA5N34W5zewuV8Ryw3cizyD5GxZjAzNHIsflDQ9AJWPoDNETu7TuoTupH+x9ADuP8A3e7pf3Hjf73upTuiD/2fmP8AQ7pV7rA7pA7v9/3HdKnrHyH+j/M/G/uY+sn9bq+gB0X0AUgx9ADBPoDhhyf3vd0Ojc/3up+p/wCR0P8AcHlf7jY/Urq90w+gBODIu/8AVsfoczm90SdEybv9xsHN+Z/sMnxPUPxvV/uP8iH725+w8h/SZv7nzv8Ac/YfhNi72L+t/vP3H7nY1O6NeR1f1LkfbPlP95zf7TN+0/Id1GZvV+U1YfZfbOhzPkc32XuiTqeI/Y+6WMw1fWfyvd1Pc5HxPie6Of2PU7pQ7uh6vzvd8voAQEsegpLK9ADGHoAbx9ACVEfQBbD876AMHP8ANu/O/wDqfpcn5jR/8z/J/wCz/wBz8I9W7mx+U8pH8pqav+ax/SasNnNuxsfMaGQn5W75hsv5iNntYfMWTMj+Z0ehowyfiWzGMYPjbv4mzyLujkgPxN37TH8jkWc05Ga/ici71NX4mGpkNyHN8R95uczygLYPecmzybkVsZJ+pI6ux8IZvIciF2HxJDIu2M3mMWLH4yFhLva7PsNyywGxFu2YRciL8BcInRssObF+EghstjMzLL7xmWPGtgsfAZkLLzciy3IfjLmZo6HJs/0Fm5kwCxHRB/AfdWP5B8zk3bOR745NjsLKvR/GPIMnZfwlzsdGMYw+J81WFh1feHtIma6uS/nYRybN2x/aZrG5H/Bch+Bu7OrcOp7pCzB8hHJW6+4ZvlebD5G5DN6MLv4Hxl3JhmrkntvVySOTZzY/1Gzs5vwlzxGZqx+RMnqanxkOZd5ntupzHkGx+8948bDY0PaI/aYapd/rPsHukM3sNA/Q8mMOT8zmeIueufbP+x/iHdIvjf2OZod0sQ9AHZvoAYw9AF0voBoQ+4/G93G9p3UD/Yc3N+U7TYj8rHqfrY2f+Z/g+N+Y/YZP+idjH/If63/AyP8Ag90+v2n4y7/iXX7b8if8Uj9l7n0ycz5nN2P1twftPdCPQ7qd+U1PO90Odh5D8SftMzun31j0ANw5GZ909w+w/wB585yf2H+R3XJ+91fZbPoARV919o/4n/I+F/6nnP3noAdh9CdAf/+h
      </FingerprintImage>

      <FingerprintTemplate />

      <AlgorithmVendor>NA</AlgorithmVendor>

      <AlgorithmVersion>1</AlgorithmVersion>

      </FingerData>

      <FingerData>

      <FingerInfo>LeftIndexFingerPrint</FingerInfo>

      <FingerReason>Not Applicable</FingerReason>

      <SupervisorName>001788488</SupervisorName>

      <NFIQ />

      <WSQImageCompressionRatio />



      a> When I am running
      select from test_fingerdataN1;*
      It is only showing first few lines

      FINGERPRINTIMAGE
      --------------------------------------------------------------------------------
      <?xml version="1.0" encoding="utf-8"?>

      <NigeriaSIM xmlns:dg="urn:digimarc.com:S


      b> *I do not want to capture the whole data , I only want to have some columns like <FingerprintImage></FingerprintImage> *
      *so kindly suggest me the solution for above 2 queries .*

      Edited by: user8989854 on Apr 30, 2012 2:22 AM

      Edited by: user8989854 on Apr 30, 2012 2:27 AM

      Edited by: user8989854 on Apr 30, 2012 5:29 AM
        • 1. Re: XML blob issue with External table
          odie_63
          Hi,
          a> When I am running
          select from test_fingerdataN1;*
          It is only showing first few lines
          That's a display issue.
          On SQL*Plus (if it's the tool you're using), you have to set the following option to a sufficient amount, e.g.
          SET LONG 50000
          b> I do not want to capture the whole data , I only want to have some columns like <FingerprintImage></FingerprintImage>
          You have to parse the content.

          Here's one way, using XMLTable :
          select x.*
          from test_fingerdataN1 t
             , xmltable('/ROOT/FingerData'
               passing xmltype(t.fingerprintimage)
               columns FingerInfo       varchar2(30) path 'FingerInfo'
                     , FingerprintImage clob         path 'FingerprintImage'
             ) x
          ;
          Note that, since you didn't give the whole XML (especially the root node), I used a generic "ROOT" element. You'll need to replace it with the real path to FingerData.
          • 2. Re: XML blob issue with External table
            933984
            thanks alot , it solved my first problem and give the way to solve the second one .

            Edited by: user8989854 on Apr 30, 2012 4:52 AM
            • 3. Re: XML blob issue with External table
              933984
              I think I need the help in second issue also .
              I am pasting the whole xml which I have successfully imported in oracle table .

              *?xml version="1.0" encoding="utf-8"?>*

              *<NigeriaSIM xmlns:dg="urn:digimarc.com:SchemaTypes" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="NigeriaSIM-PrimaryV1.4.xsd">*

              *<NigeriaSIMDemographics>*

              *<FEPCode>CHM</FEPCode>*

              *<FEPTrackingID>1</FEPTrackingID>*

              *<RegistrationType>New</RegistrationType>*

              *<FolioVersion>1</FolioVersion>*

              *<SubscriberID>1</SubscriberID>*

              *<RegistrationDate>2012-04-10</RegistrationDate>*

              *<RegistrationTime>17:36:45</RegistrationTime>*

              *<RegistrationState>EDO</RegistrationState>*

              *<RegistrationLGA>ESAN NORTH-EAST</RegistrationLGA>*

              *<Surname>Tosh</Surname>*

              *<FirstName>Rajat</FirstName>*

              *<OtherName>MAST</OtherName>*

              *<MotherMaidenName>SIMI</MotherMaidenName>*

              *<Gender>male</Gender>*

              *<DateOfBirth>1986-12-07</DateOfBirth>*

              *<ResidentialAddress>33 EHI ROAD</ResidentialAddress>*

              *<ResidentialAddressLGA>1</ResidentialAddressLGA>*

              *<ResidentialAddressState>EDO</ResidentialAddressState>*

              *<ResidentialAddressStatePostal>NA</ResidentialAddressStatePostal>*

              *<Nationality>PG</Nationality>*

              *<StateofOrigin>EDO</StateofOrigin>*

              *<Occupation>NA</Occupation>*

              *<Resident>1</Resident>*

              *<PassportNumber>N/A</PassportNumber>*

              *<PassportExpiryDate>2015-06-11</PassportExpiryDate>*

              *<PassportDataPage>/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCABeAF4DASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2WysUuopJpZbksZpBxcOBgOQOAfSrX9kW/wDz0uv/AAKk/wAaNH/49H/6+Jf/AEY1aFAGf/ZFv/z0uv8AwKk/xo/si3/56XX/AIFSf41oUUAZ/wDZNuP+Wl1/4FSf403+ybfs91/4FSf41oscKTVZmyTjOB3oAg/si3/v3X/gVJ/jTTpluHC+Zdcn/n6k/wAamExP3c0NJujJBORzyKAGf2Tb/wDPS6/8CpP8aP7It/8Anpdf+BUn+NXUfcgYdxmn0AZ/9kW//PS6/wDAqT/Gqxt1tNWiSOSco8Dlg0zMMhlx1Pua2azbr/kM23/XvL/6ElADtI/49JP+viX/ANDNVrjxFZW0l4kgk3Wm3zAFHOTjjn3H51Z0j/jzk/6+Jv8A0Y1cBr7SJrWqFfuM4RvxAI/9B/SgDttQ8RWWnGISmVmkQSbY0yQvqa0re5iubZLiFt0bruU+1cLq3GrN7aUf/QDXU+G/+Rbtf91v/QjQBFZ+J9O1CdLaJpVlk4XemMnGcZqv/bNpLBO6yuEtmw+5e+e3rWH4Z0+6vZLW4XyxaW07OSWO4kqvGPTgfrUAB/sjXOvFyn/oRoA6qy8SWFxbzlBKht4/NZXTBK+o/SmW/iTTtRm8mDzg20t8yYGAOe9Z2jRwf2nE0c8hvDZJuQr8oXavf8qh0RsS61wMmVv/AGegDZsfEljMtpEnmk3BKx5THT15pw8U6cL02rNKjiTyssny5zjr+Fchov8Ax/aIP+mzZ/SmSgnUbnf/AMe/9o/Oo+8Tl8dePX9KAO2uvEVnaakLCXzPPLKOFBHzdO9TXX/IZtv+veX/ANCSufl+0/8ACfS/ZhETsXfv7LgZx710Fz/yGbb/AK9pP/QkoAfpH/HnJ/18Tf8AoxqpXnh2yujdvNLMPtDq7EEfKVyBjj3NXdI/485P+vib/wBGNVhh5jc/d7UAYmqaLZ6gyOskyypH5OUP3l9D+ZqzbRNa2kVvAjCKNcAVem2RrkqAR0otpSSRmgDP0u0i0W0NvGJTubzCXIJ7D+lVo9ItY7e8g/fMl226TPUHOePxrZklQH5yDjtVdpkP3Yhj60AZum6ZaaXI8qSzSSsAu6T+FR2H5D8qW00pLI3DxM589tzbjkd/b3q8ZEP8JH41JHIpUxL0P86AMWy0G0sdRhuVaVhCxKIx4XPerreF7CYyOJZ8yTCc4Yfe59unzGrsCLIx3nA7UssCxqZY5Dkc4FAFa68OWt3qf255p1myp+RgBx+HtVi6/wCQzbf9e8v/AKElTWE7Sqwc5I5H0qK6/wCQzbf9e8v/AKElADtI/wCPOT/r4m/9GNUcl1Mo2gD61JpH/HnJ/wBfE3/oxqydbna30u4lQ4YDg+hzQBaM0soIY8DvSrJt4U/lXLW1/etod8XuH8+CRCG4yAcZFT6bqF1c6iQ9wRDFZiVhxjdtXJ/MmgDovMGTke1NYqeh4rnNB1K9numS5naQPB5i7scYOKrrqF6fDr3H2l/N+0hQ3GcY6UAdUD607kYx3rG1i7nh0y3MEpWaZ1XI75FU5NTuT4ZS5WdhOJ9pcYyev/1qAOxjP7wEfxc/nTQSdy46qciuWstUvDp+p7rln+zrmCfHOeamkv7tfCKXazt9pJGZB1PzEfyoA39PbFyR2INPuf8AkNW3/XtJ/wChJWb4aMrQo8t19oZwTu444HH4Vp3X/IZtv+veX/0JKAHaR/x5yf8AXxN/6MasHxMHbSGjjRmLSKMKCe5P9K3dJ/483/6+Jv8A0YarTf6xvYmgDlbOzuQdUt5UYl7fIIQgMcdvzqLSre4jtNSleCRWNtsQFCCc56fkK6sdB6DpS5x07UAcrpVpdwX9o0kL7Gt2GdhG0HdwffP86iFpcf8ACNPF5EgY3QYDYc4wK7AZoP3h9KAOZv2uL6HTRHbyI+/oyk7cYAJ/nVQ29ydBnt/IkLrdZAEZ547flXXdWpQf0oA5eztJ5LfVWW2mjieP92hUjJ56VMFuJvCL232S4WSJlUAoctyTkDHauriU4DHpUoxz6UAY/hjHkKotGtyoIZWGMnAyfxrWuv8AkM23/XvL/wChJTNOUm4JxxjrT7n/AJDVt/17Sf8AoSUAO0j/AI83/wCvib/0Y1TTWSysWyQT1qhb/wBoWYeFYbZ1aV3RjMwOCxPI2+9Tfa9S/wCfa1/7/t/8TQBFPbm3yDkxnv6GoVxj1qy1zqDJhrW0KnqPPb/4mqzwagXylvar/wBvDf8AxFAEgI/u8+9IeBknJPeofK1Ef8srX/v83/xNTJDfKRvtrVj6faGx/wCgUAEUDTdB8vqe9W47MAcoW/HFMEuor0tbP/v+3/xFH2vUv+fa1/7/ALf/ABNAFnaygALTRA7cDgd81B9r1L/n2tf+/wC3/wATR9r1L/n2tf8Av+3/AMTQBeihWFcKMetUrr/kM23/AF7y/wDoSUn2vUv+fa1/7/t/8TTYkvJ9TSaZIIwkLIAkhbOSp7gelAH/2Q==</PassportDataPage>*

              *<MainMobileNumber>070371133443434</MainMobileNumber>*

              *<PortraitData>*

              *<PotraitImage>/9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a</PotraitImage>*

              *<ImageType>JPEG</ImageType>*

              *<ImageCompression />*

              *<CompressionRatio />*

              *</PortraitData>*

              *<FingerCount>4</FingerCount>*

              *<FingerData>*

              *<FingerInfo>LeftThumbPrint</FingerInfo>*

              *<FingerReason>Not Applicable</FingerReason>*

              *<SupervisorName>00178848d8</SupervisorName>*

              *<NFIQ />*

              *<WSQImageCompressionRatio />*

              *<FingerprintImage>/6D/qAB5TklTVF9DT00gOQpQSVhfV0lEVEggMjU2ClBJWF9IRUlHSFQgMzYwClBJWF9ERVBUSCAxClBQSSAtMQpMT1NTWSAxCkNPTE9SU1BBQ0UgR1JBWQpDT01QUkVTU0lPTiBXU1EKV1NRX0JJVFJBVEUgMC43NTAwMDD/qAARRklOR0VSIFdTUSBGSUxF/6QAOgkHAAky0yXNAArg8xmaAQpB7/GaAQuOJ2TNAAvheaMzAAku/1YAAQr5M9MzAQvyhyGaAAomd9oz/6UBhQIALANVNwNmQgNVNwNmQgNVNwNmQgNVNwNmQgNvewOFxwNaLANsNQNZ4gNr3AN6QgOStQN4CQOQCwNyMQOJCAN8CAOU1gNPSQNfJQNXzQNpXANazQNs9gNiFwN1tQNvwQOGGwN+ZgOXrgNvgAOFzQN8iAOVcAOCywOc9AOThgOxBwOCOgOcRgOTlgOxGwOXmwO17QOmwgPIHAOSPgOvfQOjJQPDxgOQcAOtUwOWmAO0twODBQOdOQORSwOuWgOfGgO+7AOrHwPNWAOafAO5YQOfIgO+9QNlIwN5XgNqjwN/3wNsbAOCGwNt2gOD0wNwSgOGvwOGqAOhlgN39wOP9QOGwwOhtwN8AQOUzgN1zAONWwOFRgOf7QOCKgOcMgN/XAOY1QN+HQOXVgOMpQOoxgOApgOaYQOcwQO8GwONCgOpPwO6LAPfaAOGoAOhjAO22APbaQN0IwOLXgN5jgOR3gOgvAPA4gOp1QPLzAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP+iABEA/wFoAQACSWcEK08AAAD/pgBdAAABAgIGBgQHCgQPEQAAAACzAbWytgIDsLG3uASur7m6uwWsrbwGqKmqq72+Bwmjpqe/wMHCw6CkpdMKDJObocXGx8jJzM3O0dgIlJWXmZydn6LEytDS1dfb4/+jAAMA/wCf5/8AX5/0/n/T935/n/b+Pr7fb+X/AJ+f75zJ9f8A37X12128/wDi3n4+fj8vx5+Pj8fH/b8P8+/l+P5fD/T9f9/18vl8fw/y/wAP8f29uvX4/r/V+r+s8N7fs+H9vv8Ab7e2VH/39f8Av+X7/wB30/ns6CbsTnJjbZp4NZEDUffqgibvrgFgz5jhzefJSQox4ojEX51lwKO90Ccd2YRF5WM+vHHtmDPM44kmKS74GpaFLuK+6zCcNQIfbsOrythNohkYJpeBCITYAQhNbYC5KusYy2ozlRzwbS4clmKLrHDl4VlvE8Qm1O+VejUmkFwoVaKy1ZsoJpprGIdWYLt3rd9HN3Imoq6iFBSFImolMiaQooQoCgpE4sSpEIWYTWMJ1EG9lAPDTERM7CiSU1m6ZnbLuprKly87UsJsq6b3TveUVJpvERASUcJ2zelmoczICwm0IRRotlsiBTLbjClMTFMNCdsK7unDENhvQuDlwA2wIEygPJCcqW02KBnO++d987788b54nkTo8TrTVShSVPW2JwpQ3SZ14tlTaTpGDnr3sb2HSU6O+dcK1YmbqXG2WhQnbjriY2zhNtdc9vbs5ieIbwT2Tmmb94e5Ksu3rt3jXhrPXznjbMZvjPbfXi1o6+tp32lrNt9nznx7u3rtidu+2+03nXh29buXE39IXp8Jtb1tx23XNo9fp367l/a/NqY13+nf6RcjfXGl+J3ebYN9hyYeLS5jBkYopErDoYTHCbcNNNFJcRNrkQpodChLhooU31b3pD0uYeuL5Tb0JktMQaEY68XwrudZq+3f077ZJluaW329rZ7NYFa7Uc7Yi126SQvPHPp8+61mEPDWvs/LHCmYDjLys79hCiYc4id799d/PNt5WCcRmfn48+XOzhxe2TZc/Hhxm9NVjeNeeL7ca8XHM9eTb1JL2lYFn05nb2V+/aXD21fb6OPaeuJCaBO9o4x6a4U7w525zY53vEbdZyzHq7mO/G+I1tkMSWbRjCjYBQhpup4DQmioVb6CYr6T0igr6T7pEBRurUhoVJlo0HV1CKPR6YabQ03nDBR7plZdWaNMeJo4HWU4mUzAUcyNrCig6gDcwmjRqJcZhuk6CKZFCkTahTfORkpoqwWE1NHRzRoZoHQQ0Ojq04hN0AvSBpjCjc6YYx+40lQBUTHSXHQKN6X8BCehUB0cB7ygUaKNpsamdG2x1goNSmooEp3cqatFJE2CEUAIFM4qVE67Ye9sJ0aaE5ahzSRpxNIkmhW9CSKNoT9xMMgQDYKMIZKYwwoBlYpdsTCgxiANBoaKEwClBQUjQCBoq2mn+h1cN6CE4RTE6BLTdHL6DG5n3Mq02aQJgiFBpdtqAhorCwpoDKSoQnINp0FGJiHdOsoUOI2uRNWplOBwNuUxYYUHMJp0dJanoNPMYyhg50neHNHgKMh4hqBzCi+K5KRpMl3GGMlCdQndA8vBFS2N8KG5wgE2nCteJxKYnhjdD3uQdRgE1PBymFR6NTRj/SVZ4CEIbqyfBg6tDaGmNMQJt1aDAYKACdGxGhRtzMlZT0ZeZlSyjoAxNlSHUTZSE0wQNtAKJG3AyYFAITRCvNx0KNMaJ8IaamjHoxAUaaHIxiEMmgUdITTG72ta17RaDbta0EJtcRlZ19W0aTObqZvKApm3COF4/VXq9e/p9PLe3l9r/j7UJ69/L27ev4/PWPYhHHpK+fjt7cijOaT13+1uPp6/htzHiRTbfXGv3/1z7eL5877x14x8P3+a+/49e/1erd/n19u+38P2bfL4b8Z1319fL9vw/d8O/wB/r8vT6KXr3+Pt23n7ePO/l6uJ1xHb5+Xx/D5eKvTe3Hp9fH2+Wf2/x/hv8u641ne3Jf78Wx/v2wsLXnXvtxv2PP18spqyxbGDx+N8W0cSPPlzPHXKiaiL4ktjJETdQ0ceQOSooTUYzdw00Uam9HQjSJtje8uj6OHOzJoVjHXOvMxnFtJ7bxO2IwrZTRiMZvFod8q7VpscduPTNpiMwdZvjutmNYWrNefS3tvMxhWb3jHzf5Q87YIo9db65v139MyswzXjJjF+TOrMXzc8+O0b+f2+Mq++07Lr89/h9/Ldod7K6tv7Y17+kq6zbfZX4+X19O/akX1Weq231fPpjeHmeFrGvMflvnbMGfHjaC2OI8dbYwuvz7/Kxb1+f09uL+WG+evWmu1nxxvbbM+WrZfXUU77ivkazzvvvvnjfnnON+eGIBXUbLICKE273O9u2E06OMdpx1nFzQsjIcRGc6FSLu3C8ikEKOrzf18vb7UIU7LmLj+n4+mRzJzsKcW1eMp2gW5Gdp25tA++EK2donONsKVMopG6xZxKxuil+Ox5ze0S0J0/Lvz8/PhjWETeOba9t4EYtmLuWptGU0zUx1jbfv7b4stk7hrxysevXGFikwnd8u++kKE1h9tbUKOkTSdvHJDQmy+BY9Yd6SxXwGLbNjfRpwhgVEUtlooaQtzjYMo6SrK0t3Ok0xS7HPRy22r0bo5wLHeb5ZJNJQnq3GLigiYUdvUJvmLw0S9d7zMX2xNyIu97tA8TrdQs8zfAhtZzKfOMtzMXm2MxclRFm2rxjJS2LTxEIuRmmObYtHKlRO6cx2ndXvinflZc3w9vovMRt7YgIiONdgnu9azZuz3Lz1ac0GBTe8EoeGnhxinDTZbXW8Ti8LXu/eJ+B0ZQ0H4CfR1ECbGno2m6CJfgIUVHoKE8zQBNNCE0Nul2OLajTBjw6TcTacEnCB5kKOrTQobad5YWFLTiKvEtzTFJCgoiXEUgh0HGE4cThAomE+FdYve7bm902rEgMiZWJpGN8y4vSFhyoUS5emHAr67bWxmQCATxlq7lqBH6DwCooR0afveh0dITR7oY/e6lZqVY0+hQQxt1aDR1aZR6BDQ4YIZQc0PBtxKGhlRo6CdZETDExBQdGwdQYDKMY40CLp6A6lHRw6sIoVcUaYhDgq6RRsdCaAIG5KturZpJ737n0lHSegglNoHpIn4OjbHUafviZ/QVEJlG6CmppCmWYUMlS6ES0+k0mcNQjwAm+va0sdGnJE75KQdITvjcuLNG7XV4hXUoJUK9oLUIuMdGDtfM774bITi5aclM0k2xkI7ifOZHiSQ1ave2AVkIQ1KyUbiROakTAPM0LQyXEyosxN/pKvQQisdCgDq3o026ng6gz+4oyo9DRt0NBoq/BjoJvwAcCu9GS3MibTUaECadR0abbdDo0MEJtOKuRwDQDUTF0UmrKuWS2nSU6EjZQBMcA7slENCHRpjhg71iYTTEYlDKRWUyMMqCBNPM7hpJ/6YAhQEAAgEBBAMHBwwUExEOBwAAs7UBAgMEsrYFBgcICQoLDLG3DQ4PEBETaRIUFRYXGBkcIWqwuBobHR4fICIjJCYnKSorLC0vODu5JSgwMjM0Njc5PD0+P0JEUmOurzE1QENFSElKS1BRVFdYWVy6LjpBR0xNT1VWWl1eYWJkqaqtu7y9/6MAAwGHYbnkOrsPEYaGpcs3GJClaQsxgbOrlGEY7CNgsWBY0pYYlMHQhZuQjWSZYQgaOYxgU9Iord1VhM0WQrNMRG2YZouNFBTGFsjRoQLEdhdHsZl6nublGrq02fU0WLNI02dzDiDwQ0SgoSG9sU8ilsR0IbynRgmmI0TMLsAKSxQlG4jBHGhoFGrC5oWSB4iGjTTY0Y6upEo6mncnFYNkuxYRuLY0ImCBTGESBAzc1Gc8sEoJjAYjCm2KCiiZtiJRZhHTMIKESGXMyDYzjOLFijK6FBASm6U4uGNsi0MYwopjM0PyO49BwdU6mEbuzZ6mzGjYpsN2goo6gsWeJG7SRhcobDGNiCUWcJsLYglm7TZh1K2LNhPhIe+6PmOQG5bvidHUs71pbMOp1aVu6lhs6PA4MepBdWFNmLSw0dix1FGjHiXd7q0WOw607D879bq0WdzR1EOLxfI9x8b6H9ZvXqKHqO96hTtLlgs0b2zTS03WnQ0aY7ldGBFuxu0tixYo0I0aNEYhYgQDgViObMLFNnc3MR8z5X+c7TZ0POcmz4nzux3nifjeTuHY947TxjsOp52x6GEYWOByELEE1Gi7Ypi0XW5C7uIUXdWmMHU0IIQouMdHCZBjClEiU00BTZKIamrTCiimEbG4NQ7l+QfmPI6NjtOCLBhvxHtYOjZjyCxZo0OGaEiLCxqw0KbNm72tn0Gj3JuNc7wueR2eKbG5u2YXaYFJokaKDUiRhq0wYMViU3WiJZDQpvjRCI0wp52IZI4hDJGmgMwsjEi3YlJTM6ZWDq2IRxfDWbYNGhcFYzlsfCY3OruPEdbuKChhTo6NiB7g2LLRG7G7TqbPIoi2KSiMI7NncRs6tgoad5TTHVYwsbBo+DSHa095xe54NiG5sb3Yh1m9o7A4LBjCOrQUatyx5HVIdTZXQ8Hg4nwH0nnNz5De/wDR+F85wdGjY0Ox1NG49gcGPjCOhs8Sg0NxYjcgGhTA4LTo0xsBHrdQ3C7iMI00bL2kf8XV7ijinkOs70uOpZsWLm8eTZ0dHUjc7je3eJcubER0LvAd+Ofsxz588c8c/Zz5455YqxydMxhfDbp/HLuxbDzxoUkDGcxthIlE5mhMRwvP73m4gc8n8k/2xj/bndzhTp7H+IzGMJOcQ/j/ABOcyQnNwZ6e3+XtOcZ7RhnAOZnnnGcwTEIA5KJzfvei2Montns9n8s0WxDH/wCfy/8A32/fzmSxmsPP/wCj7+iKhkr/AOf4iYpwZAOiRgwps/7exxbFkhz9jOlkC+TVYQt9+MwCOhYNhmNG7zyZyOaNMlYZg0XLHGhZYLkg51CZrnXPLHOY0rWfvp6GTn0TDfnGE6Yx0hmmGB5kyRTp7Jz9jn2+3OKOftnT2lsezAvsy4LewM9OmJ7c9MuCZZz+8U6dEx7IJ/HGcD0zCno+3/8AsTnPaUY6M54+/OH2dD2QxlDpnpkxhowiYyYc9FhQz2pgxZswxAM4LHMIGWGSOcucuc56Zc5y65EGNGrZ34yMxE0LGSZG4JRHnl/lTRlrLnDnN3oRnNzj2C0GKMvsyuIEFx0efPo0zNZJnHRJmMwxw4z7WCmiM/8AvnRSRw4x0+/plYucJAn3xwRhnGcZzOeMwsQ0zzyaFDzhnCw0Y4WOqQgxoMXaS4jBhDDc3PBgJHcxp5FES7ZooHVrm2Uvkx06KIBiFdI4pg3xOYe052IuT2GehzcYxizTz58+kY85ks5ntxMgI25rPYOJlmc4z0mYwMwpf5GLNFC9OnTJYiUgfxOhMsxAKGJCOCCsJzYuCxiLTYsGBWExorCnMywKDR1CzGYbOpZEhqwUI6mpsYQLhQQmBIFDgpYUFAosxBcUWGmEzmYJ7ayWYuNAwtNsLMBz5xsLlzOefb7c2YMHCez+WC2GBT09v30DPbnBPbOfsCYxl+9MTphhlzAMzGY4z0cUdMTJ0gR55o55EY0zBM4dApjiF2ujBKY1iOhciXaYWNGjV0KR3liNHYWLlmFmARs00YmJgSJCMyXNVCJZ2SDCmw0mxbKkSYsLkCGbkNQjRBgjGyxIUzFkoRIQce3nTC/SGR6OebFcJGYxg6c8idClUrOKMXxjBzViIw2epORTRwEhBu0LCzdocBF1SJGLdEIsNCDhosCzBQRSEKayHSiMG2GGMXFGIOVocxgdExcQo9mIuaXFMy5VKVuuIxspBmc+zNC+wdFZzJiOhCLgWFGhFhuLqFseZ1O9I9R1sOsXUjEbOoBGzcrDQ2SEG2aY3IMbrqEcXLLcouWKwF2FmzM2abNGbohGEIdIQu6PMi1nYijWFsrZpmGghuaxz5+znz58+eOfPnz9nOOzFjvIxN6WdxTCEdSYogxsMQyQI2YsbK6pEJmJRbFYyEzWIQoXG4mazM0MWhFWJcYWDEWEIzI5YMW+LOYlNI2aSm+SgIMbtFhY6CTKOwXIbiz3O9bPDMIDsDBg7CwKNCYS2WZKyrMFPSdL56TApgg00wToDi5htlOdgGYFLOaBSYhRz9nMoYwzFAhMDWMxmKBmM3ILYxBKFjZGN84utYjWVmYRgRmOlgpbGOcyzFEVQOLRWI106dOnTp06dPb06dOnToAEIFym4jDPBomd4U0UatFBZ4upG2KDQmbgGqtjQsNERYMNc0RNGi7BpudOJCPQhTuY6thxBNh0IwYRu8CmHW5TqKeT75wKex62+NxRQOqtZBY3bLHgEYRKLBZhHZCI5xgpCyzFLTuVG6l8Bs6ZuF2EQIFyzRsuuWzQQHty6lBB1IuhHsbi9xvdBIPA1NSGbmwMGF2LTgoKIiUFIMxGYrLTGDGiIDEChgwbtIo00xY0WL4mR0S46ZmdcRaIsRho2zG2Fu4ehGOhQ2GEYFNgjSXDJbLRDet04vmKODHkEBgUXDp7M6KRrARHRoSDGiLHnCDGFDlYQbELFywI1lEojBocmQ2BWiDbK0OEo0GDHQptgzRZ0YEwkczJdj7C+LFsQaNCNmmghdjdx3voOI0cSJRwQOTCELFC0cSNmzoU3bpCyWWCN2wFyMXcPBI6lmCR2aGGwUptjN0dksvBI5jZs+I+x6mZ6mZ4kIUx1ZnqI5p2yDGgRhAxHVgtMIbBCA2CyjEdCyrGyMKbJHVuwzBmSBZGwsUI4YwdTJRmZHEKYpRZ0aOAmpZ1KaO4PCPPzj+Q8IFfBmbn7in7E9D+xfBmbn7in5Hgn8z3h87YjH9DwfyHqPdNTcdZD0ieZ+d3kO987+p8h9bR9x1vB6z3nU9D5k4ve+h+J2PE+h7i7c3lzqPQnWfKcTi+I5HAs+MdTZhc5NPe007NJsb3sOD2FyDuaNzRHcbOjqWImr406m42Y/MeUpp85wbJ5DxnIuUajwGG5/Cdb77qeVj5XtTUepp+wSiDwODwdmJslOrE0dzudx5iyeZ0fQaugmg+c5JoaHe7BwbGpoRh4jV7nrSyP1mxuLkNTZ3tJskadDiavlYMKO4j1OjR3G92IaPEdz2EbNnUhduQsR1PcTZukYe+cjgRgNL5CnYo8Zhs7z0DZ6xojc7mHA7yFmPI3twu0UavYava8iiLqcAfedjc3NjsSPFphcodR350I3DUs6G8TRsdTRyNXcWNB4O8po0fcKaLvE9wp3ly7Rve5d71tmz1sNC5o6FFmx5nUo4F25RoQu3f7nZpHg3Yd51m4slmInYXNSk5JqN2PYWOJT1tzZGNEe8uw1bFLsMYxeppsjRd4kHZPEdqaO50E0PgfeSw7jvYxx2GxsbyPUedHeQs2Hebl8pToQiO92SFjVYbB2vaxp5Lde0uxC56nxDGHiKfGx8R2v4XR7GPyvoTtCHFs6NmO97/AP+jAAMBeD+R8Hc/pOC+DoWX7i5/APsPmY/7yy/cXP4B9h8z5Dc/vf8AU7nxv4j+p+c3n9R/UHuu56j/AInvHyPwkfiPuOJ6H4D7n/qcQ+x9L9BY0f2v1n+T9D4nvdmHJucHgb38Tyf+b/3fO72x9zH9zqe6cG7Dk8ncdr3L4z6X33xm50N5dh5ze6tne6m4sdq+8/lfQ/lDR4P4D3i5Fsd5qf8AY2Y+lseo+p/4HU6l38xZj8Jwd7+h992fGcS55ngUe6cT+Z4BvOJ6SPce+dz3mj8Zcp/9P1HxOx4NJufjPM/Y/CaHlPBpXsPedzTH0lz8puI8H/Uj8h437X8B/wCT4nynjPjPtD1gdqesBv31gOa+h631gTeesBcH1gIefnPCnPWAiD6wLpf73wrX1gi6eFu7z7T/AOHQ/cPaeDieDsfuHtPBxPCyP7H7H9RT/wAnwpw/rbP4D/Q/zYf5PU+4+6/Sfif3sfgPidXwaHV/EHEj1h7pqf6PofKw+N4Nn9LyO83H6nuP8nY7HyGjwP2tjyHkdx5T6Cxq7n4HR3Gh/A5BsU/Ke89x4g7guR4Gp1H0OjufQbH4nqPgT4T5z3z7Gz3Gh2nmfKeYsfOdpxKdA+EoNjtI7jkwos/GWeJq/wA79xHk6G5o9J+c8rT8R+ss9z/odhyPfes/zPdeD5X0Fl7n8L+N+o63ccTuKfU2PmPtPlOJR/gdjyP7Xyn6z9h9bq+Rj6wVNfCRfCLOw9YD8PhVH2va+sBWHwoH1gOEep8M99YCLvrAc4/wfWBah4bT6wGTMYxjGMYxjGMYDBjGDGAxgxjGMYxjGMGMYxjGDGDGMYMGMBoep9JY/S/qPfD+l3PymxZ4H0lG83v5UbtKPUd4FLQRWlYYDsfnbtn5TYs8D6Sjeb38qN2lHqO8hdsbLDY98o1dHY4HuFFizq2aF+QbJTq6OpGix8A7i4UcjyHUQ0aB1LkbvjdW7YKdSjRj6HV0IOhxFWD3PaOw06t2yxewOJD0lPmKTc6kH0mpDUs2bFhOLoO41KLmiEOBBdgPK3LO5updLFil9BRCim5qUoWdDyMALtIMI9bvDtKNW5uIEN2IU0cixc1EClIkFd4xgQ1LJTCmnRC7uYm54ps3d6DZutMI7OjxLm8sw2UjCk0KYRhsNMets0wbrQRohc7DvSiERpjTTR8LHYjQaMwGhBNDQpo3EHcR3tFBwdQo0LugJGzoGgB2FzR2YO4ad6tO9E3m8p2GFmgVNSMdGlgjuHYNiwQiwsBsUWOBqBowodliWF3MCzGwxpu2SjRjoal2xolOjYSOiQ0bMbFi4O9sxhGENCmzTF6inZjG5Rd0aNCnRi8AhddXcOhdoe13HAsUPekdhYoUbyFCWyaOjBswjxNneNNxuxsN2iAMNVjuEdzsR1NGiNiNxY2e5Lt00bl2FlYLDsLPBjxb4CliXAoeTxdCNykhGkuQ85cu6l2GrF1Ye8jTQ2WGpvA0dHQ2NHcwivJooeDZsO9hxabsaCyO8uxSNJTZ1IahCEcBHQIcmzZswYWdxEKaBbO90KXc8G5CLGgKaeJci6I0URs2QgjRRGmji2Ci7s0WC46MYWaOt1NAu0lOpRZaKSl6iHJojRdXRaLFO9Nsci7EpsKsGzcd7yLmoQjGBo0Nh8bwSw2LO8pLNjrSl3NJZ2bBCNJTxaNDcl0RCimzDYhR5TZGMaHc9bwIXNC5CDZ0YRdW5Y6jU7lBWwaHaQo6nRjSmjRRZj3vESmNG4IbPA3FnyPyF3Vu6MbjCAPpDtO5E8xR514PlfcY2aC7HcOrvfOsdB9wudZRZoh5Sm75Gj1PuN3ecX0HYxi7jc/jfhOw3npHcjT2Nl6n+s8Ht8J891sfvP2nWcX+x+Q91sfvP2nWcX4j9Zcjs/S95wLv1H1vW+Q+B3Dcp5HyEO87jxtGp4j4Xe/Wam5ps+M9DDeXfEeojofKdT1Jq/ANyEdzyPgPIfKcD6TY3v1G4+ppjTsdhs7EdnrNV7F8b1O86yG55O94HeR95j2BcuiUw3nztKUkdnePvlmLZ6w4u95F3QjTs9hq7nR4Gh3HcQ3JuY7PqY9SasfO2PUb01PibsLn0GpvbnpdmjixdGx9T2sOB5mOr1GrQ8jg6PUw1NB0GjU3nies63gbnsKe47yPB4ronFpdR1GjvNB+R0OIlmmyOxYjds9a7PUXKfS08HUu6FmJ2njYcXQg7HJs6HU2Bu6ELtHI87CnRjcpLGr2O92PlHZ2bm4e1eJ5DrfU9TYs3LPUe+m5sm4u7OzZ73Q7HgtN2mNzeXVu9hwbHjPG2GjewR/C6vW6vW0XNw6MYRo7HuIR6275HrPcO8svWR3m4p6i5obzTCaNzvbMO8s9abgTiwu8jqNWnyvU00dzo6tjUidi8HY/M6nB7HQ5HuljikV5LZu7FjRo7DvN7uaPKfgabvzB2viaPIuy9r8xQdb5j5j6H5D/AFdXQs/G5znOcuc5zlznOc5yucuc5znOc5znOc5znOc5c5znOXOc5znOXQLn1EPWA17+Z9YCEP5nwgT9p/cw+x8I4/oP6Sj87R4NRd7T7TR+R7mOj9R42PzP7XrP8TY3j2Hxn2nW+8/EeN/Ycj5nxP6X9bQfGcl7T8Y8n3DxnAj3Pc8n6j4Hztzg+d8HV7F872G8LvyPlfidDrKKPrOB2nY975jsPgbH5TcRpj4Mp2MOJ9RGBTdj4WjZs+p8T9ycTV8T4j0vYeJ2eJ7x5Di7Oj1HnNT+hsfoYdbc6yj4H1PodWn9g/nPCYdxyOw/S/Sbz5z0v9D6jV9x/wDZ5m74YB6wQ7PWA1D8x4VL9R8J+Q+42fC5TwsTqPK/jPBoP/B8B+t8Ik7z+94O48zvfMfE954Mp6wEHfmP0vWfwf7XuPtO97TR8JF/AfvfDAfDafdPK0fQcXkfSf7mje/Wb39DvPU/Qdh+A7X9B9r7j2H4XzHrAac8L58JH/+h*
              *</FingerprintImage>*

              *<FingerprintTemplate />*

              *<AlgorithmVendor>NA</AlgorithmVendor>*

              *<AlgorithmVersion>1</AlgorithmVersion>*

              *</FingerData>*

              *<FingerData>*

              *<FingerInfo>LeftIndexFingerPrint</FingerInfo>*

              *<FingerReason>Not Applicable</FingerReason>*

              *<SupervisorName>001788488</SupervisorName>*

              *<NFIQ />*

              *<WSQImageCompressionRatio />*

              *<FingerprintImage>/6D/qAB5TklTVF9DT00gOQpQSVhfV0lEVEggMjU2ClBJWF9IRUlHSFQgMzYwClBJWF9ERVBUSCAxClBQSSAtMQpMT1NTWSAxCkNPTE9SU1BBQ0UgR1JBWQpDT01QUkVTU0lPTiBXU1EKV1NRX0JJVFJBVEUgMC43NTAwMDD/qAARRklOR0VSIFdTUSBGSUxF/6QAOgkHAAky0yXNAArg8xmaAQpB7/GaAQuOJ2TNAAvheaMzAAku/1YAAQr5M9MzAQvyhyGaAAomd9oz/6UBhQIALAODFgOdTgODFgOdTgODFgOdTgODFgOdTgOnsgPJPAOo0QPKlQOWEQO0FAOkXAPFPAORwwOu6gOFhgOgOgOHrgOi0QOYTAO2wgOFAgOfnAOCiQOcpQOEEwOefQOJhgOlBwOKuwOmegORAQOuAQOnOgPIrAOnfwPI/wPE3QPsPQOWVQO0ZwO3EgPbsAPQowP6XgPYhwIZ/APJawPxtAPWiQIZvgOjggPENgO9MgPjCQPETwPrkgPCPAPpFQPCjwPpeQPVpwIZowPBDwPnqwPN5QP3EwOQDAOs2wOdSQO8vgO0zgPY+AO1ugPaEwO9vgPjsAPE+APsXAO8swPicAO+IwPkKgO6NAPfcQO8EwPhsAPTWgP9nwPNGAP2HQPBhQPoOgO+OwPkRwPcOQIabQPJ2QPyNwPTZQP9rAO3BgPboQPuEwIckgOl5wPHFQPxygIdBAOqvQPM4wOmGgPHUwPksQIbcQPx8gIdCQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP+iABEA/wFoAQACO+wELoIAAAD/pgBvAAABAgMDBwUHCA0QGwAAAACzAbUCsrYDsbcEBa6vsLi5Bq26u7wHCKmqq6y9Cqeovr/AwcIJCwwOD5aepsTHzdPVDRAVGR2Vl5iam6Kjpdrb3R4gISIwNjc4Oz1HlJmcnZ+hw8XIyszQ19jZ3P+jAAMA+z3Oduv3fd9p7PXofZ/18fr9fjrt0/5X6v3fX4eXh8PH9H1fs/0/z+rfx/v/AE/r/V+f/Dby/P8AT+j9P0/SvT6v8v8AH9f0/t4+3X1+H7fDHu+7/j49evw/3+38Pw/8/wC/w+/7/v8A3/v/AI/x/wDv4fw/91ra5uK7Lzza1amVR4WFquZAtN/NNj06eSGjZaVEpjYTqwQKjZMynuK46G9+tHADwrk3TawwlxtbZNt2d01TQCEAMW2xq7Y33zAsXbWJRLV7i2VIBDUu1KRqk21LcUyBDbJqJdG5k7HcS08YTCpLTAMYWcTk7UItIwYQ7jiXDTU0UQ5s3aWpY9uU3CQHNpHTKTE7ymQZOWtuQCcUpcCDOYmRoiZMZXTpCGqhxdqXBKJKtLMmqacAN3TY1VplzIq75Uy6BpvKRwDvm6n56PnZ+IafzDxWMOZWOj3rFYRua89VJvry36vz0BY54LBubSRjSiHtDbpxL1axraRttO8MobcOHYxLoTsy26nJw7Tk4GCbI1hyCLMjZXimCIYUIp2Y7uMDFsmnFyzGENkt8mgBmQhpw3Rk7EB8rTpv5T1H8gmx0MvSMh3KgN9sxk5Pd3yl0izp62xLTlTJjnzxG9RQJurpwUphlUnSFtdTDlG22xa9DLN0TF7ilThVjp03amt+FKdOqTjV7vEDpEkUbvjDVIpkYaxvM5Y2IAWLjFUFiBogM6dqrEV8mKptwd7df0u00m1Jk8mmxPkOGnZ2eTqHDsyxydm8mmgcw4dmRSqhogcASCZydnQnTydnIfI4GITbZSmKgir4QmhEuzc0FFCbhuh4Q7sJh4vgvTKnF82JuiB2bmN9mneizaac1Jmz5w+c+g+gQySxDyEwGROZSIqBN2KRDGJuxnUCKcOGizGMQjJoQDV3BDG5diJhtxOdWKsJjB2GmOBq8TRBG2IFUwNU0KYNNwanW8tEHTnvJW/GEZVp6c98bePltrJad/L08b9V7fR92/P3eW/X2nN5EPTpzx1Hk8z1CPzH4nDZFDuZjVVhlBmJ1VQzulkCBVk3ANMgzIGmEyNXaIdNtpwQMGCmXEyOwjbnz2jFVjN9ed9U+u8CfHC6eFIb7eU0a9qkxOFOnU5rjy40a48Wnvz92vPiLz153cTxp7fNNt786sbb7YCHVZ403mhg55Vri9CBEGRQ/wCwRDTIEWHNqDIs7CM3DVJzFWeTHMA7SyBGIeIebacw4eCG82QUm6VIdpeBN2N0YvL6ShEAcY1QvNg53Xl17VozTrq7rTetfgt7xxeilr4Hj7dd7wPEzOq568+0u1Xq9Uq3vh5VDuKR4ycOXOHNd5goPyNH5m7zM6eflr5bOZm8p7649OF0vPVvJ415673OL5np5Hbe7d6rK+1PQxiZxDU44vPSrziXh29Naex0UtSC4mVeLiAQr7bzhvDTgyHtc2ZApsBxim05prDQ5E3amiBc6mJaHy3LN3sQ0NSSeqU0+9uBMfe0yH/UfQ1ecPasHJkTfGy2rkJ05b5TUoL1t28Rw+21jE76bcVF2nDkx7fT0qL7LZD2xPh4eHNrptWtsTjf07cNX20cakdPT39mY9OnTBv0RrA1ijbd6+etJ1ctPm+OqO4T1vsESKrEc9FWWLCYpLDfc1vYM3YHTRypqon5nByf9FcY3kO2x23xvjcRPFL9l/TwTQKab8dv9u37vfoizm/l1rz9nw03IYr9vP1/X5e/x4vTB1jT/X3/AGe/2Rh2rXjb1+z6/XPS6dJt6V16/DTt47jIntp0+P2YkqUMTK049/luxClhQ9n53CnVmqq/FOrSyxUa1KadcnLVMROTgqU6MwcUOxk4kUjH3FJo7nZqRPJ9773/ACuD8ZTvVXzFQtk5WIcTveVibrGuuVa1uPCoxvYrhgjjS6kTXHnwA9fipRFadr3jX2+AxoXX3ezE9dL/AAwi1zzuY8fj4eUjTCuvasOTjjA4o1C+nbi8idnjjbrfaU1RDQr64pOoIE6W6dMMPuGpE+8WCJTybcMmZOThpyd7gVP+d/kH8ryqBnex5tHyNHe2m3DGz5Wznztecm0OsITibSqpuopkCpc/Pn5c0706iZXt9OMbD7b4BPG+nG9YFjx87udadTvz4tOznGszi+5LRja5vwm5xM5VtOrVCxcTeVCaH6pfqMzvcAzuMmf1iE0xpuj1FhliwjIzE7CEPJmQNUEXeQTkQ6RDgRDTG025TtLQ04FQZcCGNOavxpSdNXir+fwNr0uJc079fHjGvPcUwx6dNvatSoGMnRVh3sIofN3UlPulVa9chOlQie6mJp+o/K/5mgkIYizQ3DV5M5iUCBPKkMcPFZTKadnsnZ0J2Mdt8POocq+mnMak3s2OunSGYsxEoLbazcfHT4K95pMrHSlrOo05QOYfDhosAyZzLDcNMTKzcNSQ8yhw4b5DIZ6iGh+o/tf4yGqbfcIyp5uGmnA8iBCHyGhOw3OUuGiwENoOTbgQNMRycUNMcOou0VZ3ocvITHrvKKM5YJop5scEsLNOXmNkDtTsPuGMsZCOQPuID5mp/uF//6YAfAEAAgADAgUKBxAaCwwLAAAAs7UBAgMEBQYHCLK2CQoLDA0OD2mxtxAREhYXarATFBUZGhscHyAiIyYnLa+4GB0eISQlKCkqKzAxMzQ1Njg6PT4/QUlKubosLjI8REhLWV+tri83OUBFR05QV1xguztCQ0ZNUVJivL6//6MAAwHJ1rLtYLtwYLuLczweouyQwpBDIMtNFG8glgpstaDAyQgQZoUwwaWIaRNC2jYdNMCE5f2ju7uSW5k+zu/rmwYcxj2f25+3TJzjl7HI2vzEt33DgeIxYdj4HE3m12sLZuXYCWEpsJg5JRZKRNM4DJz0poxETTIpg618x1CMJJBYLuWlxLsLBTdIcWzgQhk4lG1kkM4KBZSCEhhhnnTTHLnoz7aZz/TOOfOTMghfZp7NHQleWjHP2ez+pA1npmv/AD+un6wlnNzM845c88NDnTHMwHlc2KeB8xibHF3GwubzrcGRpyNZYgHYuZYssEtMrrBKJHlZhzbDm00OlI0sJAwfpk3FptpY2H2sN1yNRreDRwbOLJY4Gsssux4MmpkxAhpklsXblGTS5FLsJM9zYNo98PrdR0LwfWZHWfK94o2ZwXSSh1lFMMmRRZ1kPLAuifkwHfMCXg3bGDQUanpMmxresp2FEBDiSyXYYJaCWdLLJTJZZYIAwVCSMzHTSCdLtn8XxnB8ruNRc8T0kuLrbkOp1t2kyIZcSxrcjUS/yWWHUFx2MuohubjqcWx0FmSiWUogskc9TGnJefKXNhrPl7f1zznOQSDPSEy7iOSJQi50JYkIYc9PCSw8X98i9TuJNbDd16FzJ2ZsaGAWREpuwdDzMWCGFxXAsyyw737mzk72U2HfdTiy2dRA7W7iylFxo0paGl1DRLLK5FyzYxYaTWOsVIcmiHWQMH+rk4njJdp53WwanJksYgYMDSy0WRg4OLAwSaZ2Bs9RtN7vP5GB0nwPpGglcHpVp2BLAXYbhTd1rJikMMFwghhXTHOhhXALEOosf9z7DB4GT+0sdTLS4sOooxJd5rKIMnFyLOx/9EGA0a3AkwMVpxJLtFlxcAODkyZNlXJguSwg06WLLbSCQsU07Qk1FjFLELi8W86WnxssN3Y+Y6mXbnkYrLTDA5NGJdMjqIJdxtJNr+WfLPly5ctI5cjPPPOWOeZ3d3tc9Ia05Gmef6co0JJ5R3Pt/XMklgg7oz/tHPHnn7ecac32MaQQxz7v0Y/X2e2CGh5e3+ujBKEaOfP25/8Azu/XNcDT9P8An290jnjp/wDf/wAJQQrGf66SiQxpIc7sNlGy3WWc4BJYJYCDRpoph1kZ6cHsPM9OYw589KZHQSdNNC+ZRpHP2MsOkaGjnHLSgzDQnn3MFuebpZ5GfKdCNOTyXPnzWc+79NM4e7nAZ05uZDHdLbPPPnOfs/sLGksMcx0ly0I7i7hyWDIrMdIDIsw3CCiDW6EGxkfgfgNq6Mc9OfONFVo0nONOUOGkOimTy0o0zbg593dCJdSXPNyJz7tIcSzBJDOdLAmvODRaCSBCC7DpBC3ILhLJdJXY5OwnTc738wpPbBcuEKXC7ngDCw825GkEChotZi0Q4Z01nmZk6NNaOmjOcEt2GlrQhouRmBkQNiTELliSHod5KanpYf5Ei7mXAaSVulEkFwhMWmG7Cw7SSTM0ohlpVpJcDOzowWWCV1EOTJCUb3AkoFpyfQ/0NaUJcphkwcnaWLMuDDRDvIcCTaYGCSDA4DIUy2zs0QUsGAzpuHaSFiyDLRuP5mDiQYmpghxAuwYFiTBkggXRoyALAsuS2K0W4XIYcgGEsLClzrSCxk0e4YP/AAeN3jZbEm9pHMM7uRQwssCNiGDYl9CzQSwQwN1khAbNF0ohxcDF1vA3sB/Ezz5Vyzzz5Z555wrpDnsdCc45mAyMuSc8zSDDkknKDJnm5yQ02SXUwhmbHFowYWGSjrcmCFINRLqIJNjJLqZF/LOCDQMCCGM3TEpY5mQyaaU3z0k05CXRKzlcGzJZYC4YGc6BK2ZYZIW7oyGp0hksy2z1soHAKMl2ND0B/nppz058+ejpppppppQymTIFODQGRRdlsUnUYvgcRFdrrLr0NPA2nlOLYUQagtnisAQS5EEEuJLKLimtwaNRrCmjU2acGGC7BYMTAadrL0G9cGni2kFMGI6RmaYtMsuLAaOKUSMFxsBqZdgWYLgSilFlhUXqbhoWcQYDBsSG04EEvwH8EpGTFsYFad9skJYluQXFsLJCYFxhwCCRyY0hlswQyrDBRJAZwyTnjnRkQMEDduQS62GA1sMOss/m951PS8CxiXYcXsKZIbPiOgd5Tuekg8pxZmxI2LkNjgcC4SFZ++NG8YYZAu0wwZF2iWmM4ZdbLtGCz4SjUbzpfzf9HoSn6jrLvvHQP/D/AOzynjPeaZYZPE+h4EHgOLieU8Z7zTLD7r5jqIPAd83PQPY9b0Nzc/ASXPWZHjPQ3GH4jFyMTcMPnaYKH6UlsUfQYngPEZMtDvfU9h7hi72CHyGRsPCy+BNRvf7h3nAcjwNODcfA7zqIYIficSmWzTwILHWwSyQwS06z3jAosSyaynyMmsJYNTcydRcs3KYBh3Njsbuwhh2Miy6jgFKal3BkWbMsuplhcHcazawywElGp3EFiXvJiZEuw2nQSSS0w9jiOoBsEvkLBCwUbluyF2XqZYeDDvcnpaBR1rsJZJepkglQTEuUuB5GWR1gEKF3E8ZKJrUMWD4TACUp3sBvcTBskvpS7k4nrZLg+44HkCSVDJg1vuGLtYCTFfU0d9+NOo+Nl6TyF25gZJgeNgOt+k1NmXzmLLc9Z1G995xYaaaMn5HJ9RwPnf8Ac/wOLYWcX+9gxfte0DJHjDnF8/+jAAMBfdN5xdw9B63wn+p/R+Q8p0HA9LxrH5DymsucD0v1FP8AoccM4vDQf0XYcYNh4sz6z/ZwPrOLWS/vdTqP5PGPfO6z6g/2esOkbnYbnyh2EODuCT3i71kGs/N3OLJ9p3yD0G91O095s+B1sFjxGwpewpIKCTwG5917xcPIYvhcHWSQvlLNBcIcAohPdMDg4pAXIXvksLgdLAywtnrIIbFj5yGSy6yzk+UhoxYdzLL7hKyFMGDglEjB1F2S5im0xA6DeSwEjgQegl2uSSanyGBDcKJMh8RTYwJCCxZu++XbEmDDDKnvFkxDJfW6guw+okyJCCzZ9JrJR1PlNpDYs/EtjUn0EmDJ9RAQQvxnaAmprPwO0Ef3tAT97QWyO0B3zjSnGvPQfzeL+ca51v7j+LxfH9p3j/FPqIf2nGQPveOOe+cZQ7QTEfwPW/8AQ3HB40h771n/AIehydrxkT33rP8AyybHvPyuL9R/kwWf3n+DY+58DT8L8r/ceFwZcCHznSa37j8T83Udbg2frWnBaPU7mDxviH7mzJco6X0sljeeM6mDxHkPG9RqLh3x9TqfoYaaOhu7ToLGIfEWZDEo/aUSuRvNptZJLLBBC7jB4OCsBCssF2A3ENiF7GzqN7Y6wswC4hDuMGQ2skLBJLR32CC4UwQYksF2CzAS9b0pJILTRL2NnYwYBSwU9JqIdSsFMkNzpLMhZsQyS0Q2JIcX0sEMGshbnYMMu0cWBZPGwdZBksNPQ4LTk0hT6jEZGnUfGwahlggwfUWYLEmt/mS6nU7R+x9DgSGJY+VskPzNOs/k/Myd8+V/g7Ti1vF+O0KBTtBAh4yb8Z2gMAbDtAbR43pxcXjJHGIO0BaHtBSgAAAMwM8wMwAAkzjPPMAAzOWYZmYAAAd4gs4MMsEPpZNQSNFO58LK6kk+ExIaQIV1j6nBlllbnmJWGFYZYZLPvqUstySFpgIfMwuDRBRAMMI0wyw+MzzAlRsAssZ5iq5+lWzLLK3PMSsMKwywyWffUsy3JIWmAh8zC4NEFEAwwjTDLD4mAswwwSA0wS+YkDIClhgYKfdKKYCGSCFhwJGH3SGkgZVYaBSSWHzhCsK2JLslEHfaYZYIWACFhgXUQweNGVuWIbBJg+NISFhSQIVklooh8LJBDJArAEMMCvQ95lJAMSSGGFGXJ8BDKQErpYkl1HibpJC4LDZhlgwDwJRBZVFuNkgyO8wORcDIafSBIAEDDDZJdqeFoJBYJCBgxHA6SRG4C3bmt7zDSYBJBChBLL6GBuskKSQfK2ALDBY7x0ksNEMLDDZg7yQ8CzZhAB1NimjB6yiEhsUMkFPoIYIYVYLmT5yDAIWDxnmIZPI6zaQy00Qw3OwgNqSAsOLc1HB2MjBB8xiQQwAb3yG9gCzvfI6iUPjLupJCxZ7z5sw/foy3LPxNiXrIPgcH3D32TYbH5SzBufkG5kUPY5Fzseo4PzvSWd74XjKtEv2Jg/5nF6YfxfO99wPWfefk635i5g/uMT6X7ztAiI7QJMfyex+Z9T5WGxxcDvH0n7D63UHAo/i/efSfsPrdQcCj5Ta4tz9x9L0tJ7ilPSakye8MknYSU0vWZG1ycHsYfdbB8L4SSGWXY4sEuwsYtz7SH3y7raFpooIfsJbnYjuaMC6HgSzgHSN2CU4EFix3mDcQu0s09TDQy4MnjehMmxd8DJR0jBC4PSYkO5sSwwQ7nYYPQ4nB6XIlxNpueB5CQswEMHSwg7zAowdS9DApD0kEssut4OBJBgUwWIN5Z3kJc1DLieYhpo1knfOwWTWJijR7rTkMJRKrB8BJJkODL6WBlMHAksazzMJJilj1JcpbNPYyb3W7DJo8RdlsWPhMiXIxPdeggseluS6nc2LPpKPtT72CXvHxPrfAfaf9j+LxdX735jW6zI4s5vONi7T/ABeLmfidoESnaA6T+L87oqqquiq6Kq6KrCroqqqqqqqqveMDIkk+d/vLEnGEMT1ElGT9pifQt2z5zE2uJ8ZRDcwNb8BJRk/aYn0ODZ8533E+t+Z3mo+J1lISy/EdDZ+xwLv1EmD+5+p4vbufAfGB97xbz7TY7z5SA/BV+4kpufI4r9wfkv4HF6fscDE+Y+5uaz5yn8CH9jqP8iji8vG+eMA9oDoHaEOxgdoCiHyG8xeP6fIbzF+p/wCp2gN+/m8bA/gf7m86Hgcag43rxr3W9oJlPaD8P/+h</FingerprintImage>*

              *<FingerprintTemplate />*

              *<AlgorithmVendor>NA</AlgorithmVendor>*

              *<AlgorithmVersion>1</AlgorithmVersion>*

              *</FingerData>*


              *<FingerprintTemplate />*

              *<AlgorithmVendor>NA</AlgorithmVendor>*

              *<AlgorithmVersion>1</AlgorithmVersion>*

              *</FingerData>*

              *<SubscriberType>I</SubscriberType>*

              *<CompanyID />*

              *<Company>NA</Company>*

              *<CompanyRegistration>NA</CompanyRegistration>*

              *<CompanyAddressDetailed>NA</CompanyAddressDetailed>*

              *<CompanyAddressLGA>NA</CompanyAddressLGA>*

              *<CompanyAddressState>NA</CompanyAddressState>*

              *<CompanyAddressPostal>NA</CompanyAddressPostal>*

              *</NigeriaSIMDemographics>*

              *</NigeriaSIM>*



              Now I want to extract FingerprintImage and AlgorithmVersion .
              I have tried several ways but I am getting errors with all

              None of the below are working

              select x.* from test_fingerdataXML t , xmltable('/NigeriaSIM/NigeriaSIMDemographics/FingerData' passing xmltype t.XMLIM
              COLUMNS "FingerInfo" varchar2(30) path '/NigeriaSIM/NigeriaSIMDemographics/FingerData/FingerInfo', FINGERPRINTIMAGE clob path '/NigeriaSIM/NigeriaSIMDemographics/FingerData/FINGERPRINTIMAGE') x;

              select x.* from test_fingerdataXML t , xmltable('/NigeriaSIM/NigeriaSIMDemographics/FingerData' passing xmltype(t.XMLIM)
              columns FINGERPRINTIMAGE clob path 'FINGERPRINTIMAGE') x;


              select x.FingerprintImage from test_fingerdataXML tabx, xmltable( XmlNamespaces('urn:digimarc.com:SchemaTypes' AS "dg"),'dg:NigeriaSIM' passing xmltype.createxml(tabx.XMLIM) COLUMNS FingerprintImage clob PATH 'dg:NigeriaSIMDemographics/dg:FEPCode') x


              select xmltype(t.XMLIM).extract('//RegistrationType/text()').getStringVal() from test_fingerdataXML t;

              select extract(value(ds), '//FEPCode/text()').getstringval() as FEPs from test_fingerdataXML tabs, TABLE(XMLSequence(XMLType(tabs.XMLIM).extract('//NigeriaSIM/NigeriaSIMDemographics'))) ds;


              Kindly provide me the sample query so that I can extract data from the clob column
              • 4. Re: XML blob issue with External table
                933984
                Hi

                I am able to get the output from select query ,if I remove xsi:noNamespaceSchemaLocation string from the xml

                I am using the below command
                select x.* from test_fingerdataXML t , xmltable('//NigeriaSIMDemographics/FingerData' passing xmltype(t.XMLIM)
                COLUMNS "FingerInfo" varchar2(30) path 'FingerInfo', FINGERPRINTIMAGE clob path 'FingerprintImage')x;

                But I have thousands of such file I can remove this string using regex but I want to know is there any way to select data
                with the above string included in the xml .
                • 5. Re: XML blob issue with External table
                  odie_63
                  The last XML sample you posted is not wellformed so I doubt that's the one you're really using...

                  After removing this duplicate :
                  <FingerprintTemplate />
                  
                  <AlgorithmVendor>NA</AlgorithmVendor>
                  
                  <AlgorithmVersion>1</AlgorithmVersion>
                  
                  </FingerData>
                  I can use the following query successfully :
                  select x.* 
                  from test_fingerdataxml t 
                     , xmltable(
                         '/NigeriaSIM/NigeriaSIMDemographics/FingerData' 
                         passing xmltype(t.xmlim)
                         columns 
                           FingerInfo       varchar2(30) path 'FingerInfo'
                         , FingerprintImage clob         path 'FingerprintImage'
                       ) x
                  ;
                  Additional question : do you have the XML schema "NigeriaSIM-PrimaryV1.4.xsd"?
                  If so, the best way to deal with the situation would be to register the schema in the database and create an XMLType table to hold XML instance documents.
                  Among several advantages, the base64-encoded columns would be directly available in their decoded form as BLOB.
                  • 6. Re: XML blob issue with External table
                    933984
                    Second issue is still unsolved ,Are you getting the output with the above query ?

                    The issue is not because of those 4 lines as even after removing them I am not getting the output .

                    ORA-00600: internal error code, arguments: [qmr_hdl_copy:1], [], [], [], [],
                    [], [], [], [], [], [], []
                    ORA-06512: at "SYS.XMLTYPE", line 272
                    ORA-06512: at line 1
                    but If I remove xsi:noNamespaceSchemaLocation=XYZ.xsd
                    then it works properly and I am able to populate table .

                    I doubt I am missing some package as I can not run register schema also . It is also throwing me the following error

                    PLS-00201: identifier 'DBMS_XMLSCHEMA.REGISTERSCHEMA' must be declared


                    Edited by: user8989854 on May 2, 2012 1:54 AM

                    Edited by: user8989854 on May 2, 2012 2:02 AM
                    • 7. Re: XML blob issue with External table
                      odie_63
                      Are you getting the output with the above query ?
                      Yes.

                      What's your database version? Please give all digits from : SELECT * FROM v$version.

                      Post the DDL for "test_fingerdataXML" table.

                      ... and do you have the XML schema or not?
                      • 8. Re: XML blob issue with External table
                        933984
                        BANNER
                        --------------------------------------------------------------------------------
                        Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                        PL/SQL Release 11.2.0.1.0 - Production
                        CORE     11.2.0.1.0     Production
                        TNS for Linux: Version 11.2.0.1.0 - Production
                        NLSRTL Version 11.2.0.1.0 - Production


                        DDL is

                        create table test_fingerdataXML (
                        XMLIM clob
                        )
                        ORGANIZATION EXTERNAL
                        (
                        TYPE ORACLE_LOADER
                        DEFAULT DIRECTORY test_dir
                        ACCESS PARAMETERS
                             (
                             records delimited by NEWLINE
                             badfile test_dir:'test_fingerdata1xt%a_%p.bad'     
                             logfile test_dir:'test_fingerdata1xt%a_%p.log'
                             fields
                             (
                        clob_filename char(100)
                        )
                             COLUMN TRANSFORMS (XMLIM FROM LOBFILE (clob_filename)from (test_dir) CLOB)
                             )
                        LOCATION ('employees.dat')
                        )
                        PARALLEL
                        REJECT LIMIT UNLIMITED;

                        Yes I do have xsd file .

                        I have installed only two packages
                        catproc.sql and catalog.sql

                        Edited by: user8989854 on May 2, 2012 8:47 PM

                        Edited by: user8989854 on May 2, 2012 8:50 PM

                        Edited by: user8989854 on May 2, 2012 8:51 PM
                        • 9. Re: XML blob issue with External table
                          odie_63
                          I have installed only two packages
                          catproc.sql and catalog.sql
                          So I guess you don't have XML DB installed?
                          select * from dba_registry where comp_id = 'XDB';
                          You must install it using "$ORACLE_HOME/rdbms/admin/catqm.sql".