Trying to convert the data from Access DB to Oracle non spatial tables. Column is number at writer but the values shows as double with precision values so data format voilation after conversion, Am i mssing any configurations? shows problem in detail.
I couldn't reproduce your conversion issue. NUMBER is a floating point value in Oracle so if FME thinks you have a floating point value it will use a floating point value. Make sure that the FME Oracle Writer Feature Type has the correct data type set. The issue might arise in Access, so if you want to attach a small sample Access database that illustrates the problem that might help us isolate the problem.
+1markatsafe wrote:
I couldn't reproduce your conversion issue. NUMBER is a floating point value in Oracle so if FME thinks you have a floating point value it will use a floating point value. Make sure that the FME Oracle Writer Feature Type has the correct data type set. The issue might arise in Access, so if you want to attach a small sample Access database that illustrates the problem that might help us isolate the problem.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.