View Issue Details

IDProjectCategoryView StatusLast Update
0000447Database Workbench v4Data Import & Exportpublic2013-01-22 12:34
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version4.4.0 
Summary0000447: Oracle NUMBER fails export to XML
DescriptionUsing DBW 4.3.1.0 I exported 10 records from an oracle table to XML but the resulting file is not well-formed in the <METADATA> section - specifically:

<FIELD attrname="ACSDREF" fieldtype=/>

That field is of type Number (see below) so I guess some routing that converts DataTypes to a string representation doesn't know what to do with Oracle Number fields.

Sample file attached.

Regards
Dave

CREATE TABLE AC_DOCUMENTSUB (
    ACSDREF Number NOT NULL,
    ACSACREF Number(6) NOT NULL,
    ACSDOCREF Number NOT NULL,
    ACSDOCDATE Date NOT NULL,
    ACSDOCTYPE VarChar2(5) NOT NULL,
    ACSDOCSUBTYPE VarChar2(5) NOT NULL,
    ACSDOCITEMREF VarChar2(35) NOT NULL,
    ACSCLIDOCREF VarChar2(25),
    ACSFROMDATE Date,
    ACSTODATE Date,
    ACSENGRELATED VarChar2(1),
    ACSENGESN Number,
    ACSDOCINFO VarChar2(300),
    ACSCREATED_USER VarChar2(50),
    ACSCREATED_DATE Date,
    ACSLAST_UPDT_USER VarChar2(50),
    ACSLAST_UPDT_DATE Date,
    ACSDBKRELATED VarChar2(1) DEFAULT 'N',
    ACSDBKSDTYPE Number,
    ACSPHYSICALLOC VarChar2(40),
    ACSDOCLEVEL Number,
    ACSDOCPROCESSED VarChar2(1),
    FIELDREF Number DEFAULT -1,
    LOCKED Number DEFAULT -1,
    CONSTRAINT PK_AC_DOCSUB PRIMARY KEY (
      ACSDREF
    )
)
TagsNo tags attached.
DBMS & Version

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2012-09-24 09:57 Martijn Tonies New Issue
2012-09-24 09:57 Martijn Tonies File Added: SLDs.xml.zip
2012-09-24 09:58 Martijn Tonies File Deleted: SLDs.xml.zip
2012-09-24 09:58 Martijn Tonies Status new => acknowledged
2012-10-24 13:07 Martijn Tonies Assigned To => Martijn Tonies
2012-10-24 13:07 Martijn Tonies Status acknowledged => assigned
2012-10-26 09:55 Martijn Tonies Status assigned => resolved
2012-10-26 09:55 Martijn Tonies Fixed in Version => 4.3.2
2012-10-26 09:55 Martijn Tonies Resolution open => fixed
2013-01-22 12:34 Martijn Tonies Status resolved => closed