› › Duplicate Keys During SQL Insert for Oracle Database

Duplicate Keys During SQL Insert for Oracle Database


Scenario:

Received Inbound PO (850) and inserting records into database table in Oracle Database.

Issue:

Duplicate values are being populated into Primary Keys of database table. Oracle Database is rejecting the duplicate records and JDBC driver is throwing error in EXTOL Business Integrator

EXTOL error message:


SQL Error - Unable to insert record
Primary key error

Resolution:

Review Primary Keys of database table. Ensure that a unique value is going into each field.
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.