PL/Sql dbms_xmlgen.getxml not returning all table columns in XML output

340 Views Asked by At

I am trying to extract Oracle table data in XML format using the DBMS_XMLGEN.GETXMLTYPE libraries. With my SQL described below; I get the output in the format I want but XML generator skipped the last column output. It happens to be the LONG data type, which is what I wrote this format of SQL.

   { CREATE TABLE SYSADM.PS_SPEEDCHART_HDR
     (
       SETID VARCHAR2(5 BYTE) NOT NULL,
       SPEEDCHART_KEY VARCHAR2(10 BYTE) NOT 
       NULL,
       OPRID VARCHAR2(30 BYTE) NOT NULL,
       OPRCLASS VARCHAR2(30 BYTE) NOT NULL,
       EFFDT DATE NOT NULL,
       EFF_STATUS VARCHAR2(1 BYTE) NOT NULL,
       DESCR VARCHAR2(30 BYTE) NOT NULL,
       SPEEDTYPE_TYPE VARCHAR2(1 BYTE) NOT NULL,
       TOTAL_LINES INTEGER NOT NULL,
       UNIT_OF_MEASURE VARCHAR2(3 BYTE) NOT 
       NULL,
       SPDCHRT_DEFN_FLG VARCHAR2(1 BYTE) NOT 
       NULL,
       DESCRLONG LONG
       ); 
0

There are 0 best solutions below