Hi
I am getting a following error.
Un-handled conversion error on field "FOB_TYPE_C " from source type "string[40]" to destination type "decimal[10,0]":
source value="WS "; the result is non-nullable and there is no handle_null to specify a default value.
The datatype for FOB_TYPE_C is Char(40) in source table (oracle).
In Target it goes to PO_TYPE_C Number (10).
I tried using StringToDecimal(Trim(FOB_TYPE_C)) but didnt work.
Let me know your inputs.
Thanks
Type Conversion Error........
Moderators: chulett, rschirm, roy
Type Conversion Error........
Thanks,
Pavan
Pavan
---------------------------chulett wrote:Curious... how do you propose to convert string values like your "WS" into a decimal? ...
Even i was surprised to see that.
Som else has done the coding and job aborted due to this and i was looking into it for the first time. I didnt realize this.
----------------------------------------------------------
Do we have a way to handle this.
Let me know your inputs.
Thanks,
Pavan
Pavan
Re: Type Conversion Error........
As noted in your error message:
pavans wrote:the result is non-nullable and there is no handle_null to specify a default value.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Type Conversion Error........
You mean:chulett wrote:As noted in your error message:
pavans wrote:the result is non-nullable and there is no handle_null to specify a default value.
StringToDecimal(FOB_TYPE_C);
i tried but it didnt work.
Am i missing anything here.
Thanks,
Pavan
Pavan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia