wood burning stoves 2.0*
The moose likes JDBC and the fly likes Missing IN or OUT parameter at Index:24 Exception after change in database version Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Missing IN or OUT parameter at Index:24 Exception after change in database version" Watch "Missing IN or OUT parameter at Index:24 Exception after change in database version" New topic
Author

Missing IN or OUT parameter at Index:24 Exception after change in database version

lubna kausar
Ranch Hand

Joined: May 06, 2006
Posts: 51
Hi,

I am facing an issue after we have got our database upgraded from oracle 10.2.0.3 to 10.2.0.4 with a patch deployment.


The exception received is following.

WARNING: error in adding model to batch
Jul 24, 2009 11:28:58 AM AbstractDaoJdbcImpl addBatch
WARNING: error in adding model to batch
Jul 24, 2009 11:28:58 AM AbstractDaoJdbcImpl addBatch
WARNING: Missing IN or OUT parameter at index:: 24
Jul 24, 2009 11:28:58 AM AbstractDaoJdbcImpl addBatch
WARNING: Missing IN or OUT parameter at index:: 24
Jul 24, 2009 11:28:58 AM AbstractDaoJdbcImpl addBatch
WARNING: java.sql.SQLException: Missing IN or OUT parameter at index:: 24
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1681)
at oracle.jdbc.driver.OraclePreparedStatement.addBatch(OraclePreparedStatement.java:10447)
at com.telstra.ipsp.reportingframework.common.dao.AbstractDaoJdbcImpl.addBatch(AbstractDaoJdbcImpl.java:660)
at com.telstra.ipsp.reportingframework.dataloader.dao.ReportDataDaoJdbcImpl.addRecordToBatch(ReportDataDaoJdbcImpl.java:531)
at com.telstra.ipsp.reportingframework.dataloader.command.RecordDataWriter.writeRecord(RecordDataWriter.java:62)
at com.telstra.ipsp.reportingframework.dataloader.command.TextFileParser.writeRecord(TextFileParser.java:590)
at com.telstra.ipsp.reportingframework.dataloader.command.TextFileParser.parse(TextFileParser.java:122)
at com.telstra.ipsp.reportingframework.dataloader.command.NetworkFileManager.parseAndLoad(NetworkFileManager.java:119)
at com.telstra.ipsp.reportingframework.dataloader.command.NetworkFileManager.parseAndLoad(NetworkFileManager.java:169)
at com.telstra.ipsp.reportingframework.dataloader.command.DataLoaderManager.loadNetworkFile(DataLoaderManager.java:311)
at com.telstra.ipsp.reportingframework.dataloader.command.DataLoaderManager.execute(DataLoaderManager.java:196)
at com.telstra.ipsp.reportingframework.scheduler.command.MoveFilesToProcessingloadNetscreen(MoveFilesToProcessing.java:443)
at com.telstra.ipsp.reportingframework.scheduler.command.MoveFilesToProcessingmoveFilesToProcessing(MoveFilesToProcessing.java:165)
at com.telstra.ipsp.reportingframework.scheduler.command.ScheduleProcess.moveToProcessing(ScheduleProcess.java:541)



I first searched for similar post in the forum. I got one similar to this but issue was different.
we have two envirements having the same code running.

The only difference is database was upgraded on one envirement(where we are getting the error).


From the manifest file of this ojdbc14.jar the specific version used was 10.2.0.1.0. following is the extract from manifest file.(Previous)

Specification-Vendor: Oracle Corporation
Specification-Version: Oracle JDBC Driver version - "10.2.0.1.0"
Implementation-Version: Oracle JDBC Driver version - "10.2.0.1.0"


I replaced the jar with another ojdbc14.jar having
Specification-Version: Oracle JDBC Driver version - "10.2.0.4.0"
Implementation-Version: Oracle JDBC Driver version - "10.2.0.4.0"

but still I am getting the same error.
stuck in this issue since many days but not able to resolve.


Any resolution to this (except downgrading the database version!)

Thanks in Advance
Regards,
Lubna
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Missing IN or OUT parameter at Index:24 Exception after change in database version
 
Similar Threads
Oracle JDBC Missing IN or OUT parameters
Error when calling stored function using xml table in oracle
Missing IN or OUT parameter at index:: 1
java.sql.SQLException: Closed Statement
Oracle10g: java.sql.SQLException: Invalid Oracle URL specified