I've had similar issues when migrating a CF/Oracle app from CF 4.5 to CF 6.1.  During that adventure I found this resource:
http://www.blinex.com/~sam/CF_SQL_TYPES.cfm

This chart maps CF_SQL_TYPE's to types specific to different database platforms, including Oracle.  In your case, you might have some luck if you change you CF_SQL_NUMBER parameters to CF_SQL_FLOAT (it worked for me, and as that chart shows, it's a better match for Oracle's "NUMBER" type).

Doug Keen
Senior Consultant, The Seva Group
http://www.sevagroup.com
Phone: 443-703-2087
Fax: 443-703-2097
Toll-Free: 1-888-230-1576
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to