I am using Oracle enetrprise stage to load abd update data in Oracle database from squential file. Whenever I run the job all of the records are getting rejected by Enterprise stage. I tried all variation of upsert and it gives the same results.
In the reject records I get "sqlcode:-1480" but there is no explanation for that.
I will appreciate help on this one.
Oracle enterprise stage Upsert returns sqlcode:-1480
Moderators: chulett, rschirm, roy
Not that this is all that helpful, but you can look them up from the command line using the 'oerr' command:
Code: Select all
$ oerr ORA 1480
01480, 00000, "trailing null missing from STR bind value"
// *Cause: A bind variable of type 5 (null-terminated string) does
// not contain the terminating null in its buffer.
// *Action: Terminate the string with a null character
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers