Oracle enterprise stage Upsert returns sqlcode:-1480

dnsjain · Post by **dnsjain** » Mon Jul 02, 2007 12:40 pm

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.

chulett · Post by **chulett** » Mon Jul 02, 2007 1:15 pm

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

dnsjain · Post by **dnsjain** » Mon Jul 02, 2007 1:35 pm

I found the reason: My APT_STRING_PADCHAR parameter was set 0x20, It need to be set to 0x00.

Thanks a lot everyone for the suuport.