Sending empty Numeric value to Oracle SP

[Former Member]

Hi,

I try to sent an emty Numeric value or NULL to Oracle SP but I cant. It gives always an error.

I searched the forum but couldn't find a precise answer.

Can anyone help?

[prateek]

You may try sending empty string to the field during mapping. Then in the JDBC communication channel you can use option Interpretation of Empty String Values as NULL Value.

Regards,

Prateek

[Former Member]

Hi,

But when the type is NUMERIC it doesnt accept empty strings. Empty string like "" . Right?

[former_member200962]

With NUMERIC you wont be able to pass the NULL value....it does not support....if possible try changing the type.

Regards,

Abhishek.

[madhusudana_reddy2]

Simply you can select option Interpretation of empty string values, you select either null or empty string.

But your database has to allow null value in that column. If they applied not null constraint on that column you can not insert null value into that column.

thanks,

madhu