1403: update record not found

[arun_im4u]

I am loading data into oracle via upsert and some records are being rejected into my reject file with the code -1403.

What does "code -1403: update record not found" mean???

If the record already exists then i want to update it. The table is an empty table.

Any help is appreciated.

Arun.

[DSguru2B]

Try switching from "Update record or insert" to "Insert new records or update".
I have found different results with those two options, all though they might come accross as strikingly similar.
Also, make sure the key(s) are properly defined

[vinaymanchinila]

Hi,
I am loading into an Oracle table and out of 200 rows , 25 get rejected with SQL code 1403 so I changed the upsert method from "Insert then Update" to "Update then Insert", now all the 200 are rejected with
ORA-01458: invalid length inside variable character string !


Is there any other way to avoid the 1403 error code apart from changing the order of the loading.

Thanks,

[kumar_s]

Code: Select all

ORA-01458 invalid length inside variable character string

Cause: An attempt was made to bind or define a variable character string with a buffer length less than the minimum requirement.

Action: Increase the buffer size or use a different type.

Is ther any way, the columns are been mapped wrongly in database stage.

[ray.wurlod]

You can learn about Oracle errors using the oerr command on the server. For example

Code: Select all

oerr ORA 1403