Oracle SQL Insert Error -- Null Value with Execute Adapter

Oracle SQL Insert Error -- Null Value with Execute Adapter


Scenario:

Inbound 856 is received and translated into JDEdwards E1 tables (F47031/F47032)

Issue:

We are using an auxiliary table and attempting to write a record where a field is null: DLLITM. Due to us not pre-populating the field with a single space, we are incurring an error.

EXTOL error message:


SQL exception error while attempting to perform SQL insert -- Invalid colum type: 1111.

EXTOL EBI SQL Insert Error Null Value with Execute Adapter

Resolution:

Pre-populate field DLLITM with a single space. Override the single space if actual value is to be populated in DLLTIM



By: on
A free web counter provided by GoStats.