0 Replies Latest reply on May 21, 2014 9:47 AM by user11158802

    Character to number conversion ERROR with NTv2_to_XML

    user11158802

      Hi all,

       

      I'm testing the Oracle example to convert NTV2 grid in ASCII format to an Oracle Spatial XML representation and it's not working for me.
      The only different thing in my script is the *.gsa filename. I have checked with different gsa files and none of them it works.
      This is the error:
           ORA-06502: PL / SQL: numeric or value error: character to number conversion Error

       

      This is the script (oracle example):

      set lines 32000
      set long 2000000000

      DECLARE
        ntv2      CLOB;
        xml       XMLTYPE;
        ntv2_file BFILE;
      BEGIN
        ntv2_file := BFILENAME('MY_WORK_DIR', 'samplentv2.gsa');
        DBMS_LOB.OPEN(ntv2_file, DBMS_LOB.LOB_READONLY);

        DBMS_LOB.CREATETEMPORARY(ntv2, TRUE, DBMS_LOB.SESSION);
        DBMS_LOB.OPEN(ntv2, DBMS_LOB.LOB_READWRITE);
        DBMS_LOB.LOADFROMFILE(ntv2, ntv2_file, DBMS_LOB.LOBMAXSIZE);
        DBMS_LOB.CLOSE(ntv2);
        DBMS_LOB.CLOSE(ntv2_file);

        SDO_CS.convert_NTv2_to_XML(ntv2, xml);
        SDO_CS.convert_XML_to_NTv2(xml, ntv2);
        DBMS_OUTPUT.PUT_LINE(SUBSTR(ntv2, 1, 32000));
      END;

       

      Please, could anyone provide me with a GSA file to test this example ?

      I'm using Oracle 11g Enterprise Edition Release 11.2.0.1.0.

       

      Thanks a lot in advance !
      Regards,
      Anna.