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.