Invalid precision value in Oracle

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
durgaps
Participant
Posts: 74
Joined: Sat Jul 08, 2006 4:09 am
Location: Melbourne, Australia
Contact:

Invalid precision value in Oracle

Post by durgaps »

Hi all,

I am getting the following error while doing an insert into an Oracle table using both ODBC as well as Oracle Enterprise edition stage.
APT_CombinedOperatorController,0: [DataDirect][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 19.
0
I searched through the archives but was not able to find a compreshensive answer to this problem. My 19th parameter is a Decimal column of Lenght = 38 & Scale = 2.

Please help me on this
Durga Prasad
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Decimal datatype has maximum of 38,10. Try using double if required.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply