ORA 01727 numeric precision specifier is out of range (1 to 38)

[Anonymous]

Hello ,

I need your help please.

I have a job that works properly. The abbreviated logic of its operation is as follows:

when I added, in Request 1, a simple Id_Country column (of type Number) and when I declared, at the schema level, in the same way as the other Id columns (of type Number too) and this in all components (Request 1, Tmap 1, Tmap 2 and Table Output).

when executing the job after adding the new Id_Country, I got the following error message:

Just for the test: I specified the length of the added field Id_Country to 22 in length and 0 in precision but the result in vain: always the same error message.

When I connect the Request 1 component directly to the Table Output as, below, the job is executed and the Id_Country is inserted into the Table Output without any error :

PS: The Table Output self-deletes and re-creates itself each time the job is executed.

Thank you in advance.

[manodwhb]

@manalhadrach , check the below link.

https://oscarvalles.wordpress.com/2015/03/19/talend-data-integration-exception-in-component-toracleo...

[manodwhb]

@manalhadrach , check the below link.

https://oscarvalles.wordpress.com/2015/03/19/talend-data-integration-exception-in-component-toracleo...

[Anonymous]

Hello,

Thank you for your reply.

The precision of the new field added and its lenght are specified in the whole job (len : 22, prec : 0) and still doesn't work. Do you have any other idea please ?

Thank you in advance.

[Anonymous]

Hello,

Thank you for your reply.

The precision of the new field added and its lenght are specified in the whole job (len : 22, prec : 0) and still doesn't work. Do you have any other idea please ?

Thank you in advance.