Exception while calling stored procedure :Bigger type length than Maximum

Posted by Ravi Gupta on Stack Overflow See other posts from Stack Overflow or by Ravi Gupta
Published on 2010-05-07T11:09:05Z Indexed on 2010/05/10 5:18 UTC
Read the original article Hit count: 311

Filed under:

oracle9i

|

sqlexception

|

jdbc-driver

|

weblogic8.x

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 ?

© Stack Overflow or respective owner

Related posts about oracle9i

Oracle9i export error

as seen on Server Fault - Search for 'Server Fault'
When I rut the following: set ORACLE_SID=orcl exp.exe 'SYS/system as sysdba' full=y log=exp.log file=mydump.dmp in the end i see the following: EXP-00056: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00000: Export terminated unsuccessfully what should i do to resolve… >>> More
migrating from mysql to oracle9i.Equivalent create table syntax

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Following is the syntax for creating table in mysql. I want to create table with same properties in oracle9i. Can anyone provide me the equivalent syntax for oracle? CREATE TABLE IF NOT EXISTS "tbl_audit_trail" ( "id" int(11) unsigned NOT NULL, "old_value" text NOT NULL, … >>> More
how query a cube olap using a java Application

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I've a cube olap created with oracle9i, and I want to do some queries on this cube using a java application, but the problem is: how can I connect the java application with the cube olap. thanks for your help >>> More
Oracle 9i Session Disconnections

as seen on Server Fault - Search for 'Server Fault'
I am in a development environment, and our test Oracle 9i server has been misbehaving for a few days now. What happens is that we have our JDBC connections disconnecting after a few successful connections. We got this box set up by our IT department and handed over to. It is 'our problem', so options… >>> More
Linked SQL Server to Oracle

as seen on Server Fault - Search for 'Server Fault'
Getting this error when executing SQL Server query only when connected via remote Desktop. When running the query from desktop, no problem. Is this a tsnNames issue? Linked server to Oracle 9i Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' reported an error. [OLE/DB provider… >>> More

Related posts about sqlexception

How to throw a SqlException(need for mocking)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am trying to test some exceptions in my project and one of the Exceptions I catch is SQlException. Now It seems that you can't go new SqlException() so I am not sure how I can throw a exception especially without somehow calling the database(and since it is unit tests it is usually advised… >>> More
'Invalid column name [ColumnName]' on a nested linq query.

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got the following query: ATable .GroupBy(x=> new {FieldA = x.FieldAID, FieldB = x.FieldBID, FieldC = x.FieldCID}) .Select(x=>new {FieldA = x.Key.FieldA, ..., last_seen = x.OrderByDescending(y=>y.Timestamp).FirstOrDefault().Timestamp}) results in: SqlException: Invalid column name… >>> More
Oracle JDBC connection with Weblogic 10 datasource mapping, giving problem java.sql.SQLException: Cl

as seen on Stack Overflow - Search for 'Stack Overflow'
Oracle JDBC connection with Weblogic 10 datasource mapping, giving problem java.sql.SQLException: Closed Connection I am using weblogic 10 JNDI datasource to create JDBC connections, below is my config http://www.bea.com/ns/weblogic/920.xsd" XL-Reference-DS jdbc:oracle:oci:@abc.XL.COM … >>> More
java.sql.SQLException: SQL logic error or missing database

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I ahve created database connection with SQLite using JDBC in java. My sql statements execute properly. But sometimes I get the following error while i use conn.commit() java.sql.SQLException: SQL logic error or missing database Can anyone please help me how to avoid this type of… >>> More
java.sql.SQLException: SQL logic error or missing database, SQLite, JDBC

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I ahve created database connection with SQLite using JDBC in java. My sql statements execute properly. But sometimes I get the following error while i use conn.commit() java.sql.SQLException: SQL logic error or missing database Can anyone please help me how to avoid this type of… >>> More