Error when generating insert statements

Hello,

I have this table:



Note that column ENEX is of type char(2). When generating insert 
statements for this table, I get:

Insert into T_GTE
    (EZPT, CREATOR, AEZPT, CHANGER, TAG,
     ETSOEIC_CODE, ENEX, VVON, VBIS, LAST_EXPORT_DATE,
     LAST_EXPORTED_DATE, CONFIDENTIAL, CONFIRMED)
  Values
    (TO_DATE('12/05/2012 14:15:52', 'MM/DD/YYYY HH24:MI:SS'), 'TED', 
TO_DATE('12/06/2012 08:08:14', 'MM/DD/YYYY HH24:MI:SS'), 'TED', 
'001.TOAST__H018___.LAS.A.D.WM__.RW.H',
     '37Z000000004972G', 'EX ', TO_DATE('04/01/2007 06:00:00', 
'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/31/2999 06:00:00', 'MM/DD/YYYY 
HH24:MI:SS'), TO_DATE('12/06/2012 10:46:08', 'MM/DD/YYYY HH24:MI:SS'),
     TO_TIMESTAMP_TZ('01.02.2012 07:00:00, -01:00','DD.MM.YYYY 
HH24:MI:SS,FF TZH:TZM'), 0, -1);

Here we have two errors:

 1. The value to be inserted into column ENEX is 'EX ', which has 3
    characters.
 2. The expression for the timestamp is wrong. It should be
    "TO_TIMESTAMP_TZ('01.02.2012 07:00:00 -01:00','DD.MM.YYYY HH24:MI:SS
    TZH:TZM')"
 3. when exporting more than 50 row, the ',' in the format string of the
    timestamp changes to '.'.

So, after generating insert statements the output has to be edited each 
time. This is quite annoying when the output file is more than 50MB in 
size :-(

I use TOAD 11.6.0.43.

Regards,
Volker


-- 
Volker Siebelink        | phone:  +49 291 9985-20
MEGLA GmbH              | fax:    +49 291 9985-51
Feldstraße 34           | mailto: [email protected]
D-59872 Meschede        | URL:    http://www.megla.de

GeschÀftsfÌhrer        Dipl.-Ing. Volker Siebelink
Firmensitz/
Registergericht        Meschede, Amtsgericht Arnsberg, HRB 3288
Umsatzsteuer-
Identifikationsnummer  DE 125917642