The easiest thing to do would be to set the Result Field Type to String. There usually is no reason for the integration to use data types other than string.
I agree with you for that situation, but what if you’re facing a situation that you don’t have any choice to choose the result type?
I cannot find this service. It’s not stated in webMethods Integration Server Built-In Services Reference documentation either. Is this a custom service or a new service? FYI, I’m working on webMethods Developer v7.1.3.
I know that we can create a Java Service to do the conversion, but I hope I can find a solution without using Java Service.
That is fairly rare. I can’t recall a time when the choice was not available during initial development. Obviously it’s more difficult to change once established and other components rely on that data type. My rule of thumb: use string unless there is a specific reason not to. My usual exception to this rule is date/timestamps.
In the case where one must keep the original data element as a type other than string, the transformation services others have mentioned are helpful.
You will use a Java service regardless. Whether or not you have to write one is the question.
Just little curious, why I don’t have the WmTransformationServices package while some other people here have it? Is this package only available for newer version of webMethods IS?