NVARCHAR to MONEY not allowed

[Former Member]

Hi Friends,

I am doing a Proxy to JDBC scenario using stored procedure.

We have a field in the database which has the datatype as " Money ".

The data is being sent from the source in decimal format

This data is inserted in the database through a stored procedure. this stored procedure has MONEY as the datatype for that field.

In PI, i have given the source datatype and target datatype as string.

In the field mapping, i have given TYPE --> CHAR.

We are receiving a error at the communication channel. " Implicit conversion from data type nvarchar to money is not allowed. Use the CONVERT function to run this query ".

kindly help me to resolve the issue.

Regards,

Sherin Jose P

[Former Member]

Hi ,

I have solved the issue by selecting Decimal in target and giving TYPE-->DECIMAL in the mapping field.

Now it works fine.

Thanks for the inputs.

Regards,

Sherin Jose P

[Former Member]

Hi sherin,

Check you are sending the value (-922337203685477.5808 to 922337203685477.5807) with 4 digit decimal value. else use formatNum and try it out.

Format Number:#0.0000

Regards,

Prakasu.M

[former_member200962]

you need to apply some logic in udf to convert char -

---

> money datatype.....doing a 1:1 mapping betwwen char ---> money gives this error

[Former Member]

Actually money should support decimal values. In this case it is not supporting, so we are puzzled about this error. If at all we follow some logic, what would the logic be ?

money --> Monetary data values from -2^{63 through 2}63 - 1

Regards,

Sherin Jose P