Hello,

The following is an Oracle Table Definition (defined by a Client so I take no responsibility for it's design).

CREATE TABLE EXAMPLE
(
KEYONE VARCHAR2(6 BYTE) DEFAULT ' ' NOT NULL,
KEYTWO VARCHAR2(12 BYTE) DEFAULT ' ' NOT NULL,
UPDATED_DT DATE DEFAULT sysdate,
UPDATED_BY VARCHAR2(12 BYTE) DEFAULT ' ',
REQUIRED VARCHAR2(4 BYTE) DEFAULT ' ' NOT NULL,
GENERAL VARCHAR2(8 BYTE) DEFAULT ' '
)

Never the less I need to add to this table, UPDATED_DT is causing a write error (when it is removed, adding to the file doesn't fail).

The File Definition for this field is;
NUMERIC N (5), EXTERNAL TYPE =DATE, EXERNAL FORMAT = BLANK

Any help would be appreciated, even if it is directing me to the appropirate documentation.

Cheers,
Brandon

Hi!

What's the error text you're receiving?

We set NLS_DATE_FORMAT=yyyymmddhh24miss
at the environment level before running our application.
Also, we found that you need to set null permitted to 'Y' in the pro-iv file definition.

If the table is only being added to, and the Oracle default for this field is the system date is there any reason it needs to be in the ProIV definition at all?