Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLFetchScroll DBVendorCode:0:, DBState:22003 error

334994Oct 30 2002
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 27 2002
Added on Oct 30 2002
1 comment
528 views