Parallel - Insert into oracle table

[alcides]

Hi All

I have one job that insere 3 rows into a oracle table. In development this job works very well. In production it execute with sucess but not insere the rows. The log show me only 3 lines like this:
Records inserted: 0
Records used for update: 0
Records rejected: 1
Total records: 1.
Do you have any idea about this problem?
the table's structure and user permissions is the same (production and development)

Tks

[ArndW]

Add a reject link to your oracle write stage and put that into a peek statement, then examine the SQL code to find out why the rows are being rejected.

[diogo.cwb]

up

[diogo.cwb]

Only for explain the solution:

in Development the parameter APT_STRING_PADCHAR = 0x00 and in the Production enviroment the parameter APT_STRING_PADCHAR = 0x20. So the Data Stage expects a Null character at the end of string in Production.

thanks for all

[alcides]

Thank you very much!

Thus was possible to see the error (ora-1480) and to find the solution of this problem.

Thanks
Alcides