SQLFetchScroll DBVendorCode:0:, DBState:22003 error
I have 9i database installed. I am running the following select in java which is supposed to return a resultset. The select selects from 41 columns in a database table.
select
sequenceid, displayed, isexpense,equalunit,line1,line2,line3,line4,
criteria,boundary1,boundary2,boundary3,boundary4,boundary5,boundary6,
boundary7,boundary8,boundary9,boundary10,boundary11,boundary12,boundary13,
boundary14,boundary15,boundary16,boundary17,boundary18,boundary19,boundary20,
desc1,desc2,desc3,numdecimals,chartselection,chartrange,chartsymbol,fontsize,
maindisplayorder,resultsdisplayorde,inreport,inbackground
from
ifparameter
where name ='3 Month Total Return'
whenever I run the select in sql it works fine but whenever I run it in java I get SQLFetchScroll DBVendorCode:0; DBState:22003 error which is as follows:
ServerException:[ODBC Error], SQLFetchScroll DBVendorCode:0:, DBState:22003:. [Microsoft][ODBC driver for Oracle]Error in column 10: Numeric value out of range DBVendorCode:0:, DBState:22003:. [Microsoft][ODBC driver for Oracle]Error in column 11: Numeric value out of range DBVendorCode:0:, DBState:22003:. [Microsoft][ODBC driver for Oracle]Error in column 12: Numeric value out of range
I am connecting to the database using JDataConnect database driver. I thought it was a java issue but even when I comment out all the code in java that processes the resultset and only have
if(resultset.next())
{}
I still get the same error and while debugging in java the if statement is throwing the exception.
Does this still look like a data issue or is this a JDataConnect issue or what does this error code mean?
Please reply soon.
Thanks