views:

197

answers:

3

HI I am getting this exception when I am calling any stored procedure from my J2EE app.

Exception while calling stored procedure :Bigger type length than Maximum

I am having Oracle 9.1.0.7, JDK1.4 and using ojdbc14.jar running on Weblogic 8.1

Please advise what could be the root cause ?

Below is the manifest of my ojdbc14.jar

Manifest-Version: 1.0
Implementation-Version: "Oracle JDBC Driver version - 10.1.0.2.0"
Specification-Title: "Oracle JDBC driver classes for use with JDK1.4"
Specification-Version: "Oracle JDBC Driver version - 10.1.0.2.0"
Implementation-Title: "ojdbc14.jar"
Created-By: 1.2.2 (Sun Microsystems Inc.)
Implementation-Time: "Wed Jan 21 00:48:12 2004"
Implementation-Vendor: "Oracle Corporation"
Specification-Vendor: "Oracle Corporation".

+1  A: 

See this post for a possible workaround.

For possible causes, see this thread:

There are bugs in different versions of the drivers and different versions of the database; most of them are fixed in later versions.

For example, bugs produce the "Bigger type length than maximum" in Oracle database 8.1.7.2 or 9.0.1.1 for certain very specific operations using DB links; upgrading to 8.1.7.3 or 8.1.7.4 or 9.0.1.2 resolves those problems.

For example, bugs produce the "Bigger type length than maximum" in Oracle database 10.1.0.2 and 10.1.0.3 for certain very specific operations involving NLS characters; upgrading to 10.1.0.4 pr 10.2.0.1 resolves those problems.

For example, the 8.1.6 classes12.zip had such a bug on certain operation with databases in a UNICODE character set, that was fixed in the 8.1.7.4 driver.

If you have an Oracle support contract, you can find out this information on the Oracle support site; metalink.oracle.com If not, download the latest versions of the drivers and pray...

GalacticJello
+1  A: 

It's a driver bug. Your version is already 6 years old. Download the latest and greatest from here.

Hans Passant
A: 

i downloaded the latest driver and now much better - now that all the referenced locations are updated

danielle