Director warning Implicit conversion
Posted: Thu Apr 05, 2012 3:30 am
Hi all,
i've following warning running a job with the Director:
"Implicit conversion from source type "decimal[38,10]" to result type "decimal[3,0]": Possible range/precision limitation" located in the initial OCI.
The OCI is binded to a View with a join and, in this case, we noticed that metadata of number fields are not recognized properly.
The original datatype was number (3,0) but with the join become number () and Director consider those fields as (38,10) so it is warning.
We tried to put a cast into the View to force metadata to be Number (3,0) but it's still warning.
Any help to remove those warnings would be appreciated
Thanks
Tony
i've following warning running a job with the Director:
"Implicit conversion from source type "decimal[38,10]" to result type "decimal[3,0]": Possible range/precision limitation" located in the initial OCI.
The OCI is binded to a View with a join and, in this case, we noticed that metadata of number fields are not recognized properly.
The original datatype was number (3,0) but with the join become number () and Director consider those fields as (38,10) so it is warning.
We tried to put a cast into the View to force metadata to be Number (3,0) but it's still warning.
Any help to remove those warnings would be appreciated
Thanks
Tony