› › 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
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.