Internal Error:Invalid index for data access

[raju parepally parepally]

Dear Coleages,
i am getting this error when i am getting the data from oracle.Here i am using jsp to call oracle procedure this exception is coming randomly
java.sql.SQLException:InternalError:Internal Error:Invalid index for data access


Thanx in advance
nagaraju

[Shailesh Chandra]

post your code, with the signature of your stored procedure.

post the StackTrace if any

Shailesh

[arie narula]

anyone got an answer to this problem

Internal error: invalid index for data access

calling a stored procedure from a JSP

[Jeanne Boyarsky]

Are you setting all the parameters? Also check the getXXX() method indices are valid.

If you'd like more help, please post some code here.

[Sam Md]

Mohammed Sameer wrote: Iam getting this Exception while calling a stored procedure using Callable statement in core java. Any help is appreciated. Its Production issue. Urgent please
Here is the piece of Code:
callableStmt.setString(1,sRetMsg);
callableFeedStmt.registerOutParameter(2,java.sql.Types.VARCHAR);
callableFeedStmt.execute();
con.commit();
sRetVal = callableFeedStmt.getString(2); // At this line iam getting exception: Internal error: Invalid index for data access
Exception Trace is as follows:
Internal error: Invalid index for data access
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
oracle.jdbc.dbaccess.DBData.checkItemNumber(DBData.java:398)
oracle.jdbc.dbaccess.DBData.getItem(DBData.java:347)
oracle.jdbc.dbaccess.DBDataSetImpl.getCharsItem(DBDataSetImpl.java:1488)
oracle.jdbc.driver.OracleStatement.getCharsInternal(OracleStatement.java:3355)
oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:3556)

[Sam Md]

Mohammed Sameer wrote: Iam getting this Exception while calling a stored procedure using Callable statement in core java. Any help is appreciated. Its Production issue. Urgent please
Here is the piece of Code:
callableStmt.setString(1,sRetMsg);
callableFeedStmt.registerOutParameter(2,java.sql.Types.VARCHAR);
callableFeedStmt.execute();
con.commit();
sRetVal = callableFeedStmt.getString(2); // At this line iam getting exception: Internal error: Invalid index for data access
Exception Trace is as follows:
Internal error: Invalid index for data access
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
oracle.jdbc.dbaccess.DBData.checkItemNumber(DBData.java:398)
oracle.jdbc.dbaccess.DBData.getItem(DBData.java:347)
oracle.jdbc.dbaccess.DBDataSetImpl.getCharsItem(DBDataSetImpl.java:1488)
oracle.jdbc.driver.OracleStatement.getCharsInternal(OracleStatement.java:3355)
oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:3556)

[Jan Cumps]

Hi Sameer,

Its Production issue. Urgent please

Sorry. that is a non-java related issue that we can't fix

callableStmt.setString(1,sRetMsg);

Can you please also post the part where you create callableStmt? We would like to see the sql string.

Please use code tags around your code for readability. Use the "Code" button next to the Quote button.

Regards, Jan

[Sam Md]

Jan Cumps wrote:Hi Jan, Please throw light on the below code and where iam calling the procedure
Iam createingthe CallableStatement instance in ClassMain as follows:
ClassMain.callableStmt=ClassMain.con.prepareCall("{ callXYZ(?,?)}"); (1-Input Parameter 2- OutputParameter(i.e. String))

public class MyClass implements XYZListener 
{
	private class MessageListener implements Runnable
	{
		 //private Connection dbCon = null;
		 //private CallableStatement cStmt = null;
		 private String sRetMsg = null;
		 private String sRetVal = null;
		 private StringBuffer sMsgBuff = new StringBuffer();
		 private String sDBMessage = null;

		 try
		 {
			/*if(con != null)
				dbCon = con;

			dbCon.setAutoCommit(false);
			[color=red]cStmt = dbCon.prepareCall("{ call XYZ(?,?)}");[/color]*/

		}catch(Exception e)
		{
			strLog = "Exception while getting connection from []";
			logger.info(strLog);
		}

		public synchronized void run()
		{
			while( true)
			{
				try
				{
					if(getDBStatus().equals("UP")){
						dbProcess(getHtData());
					}

					Thread.sleep(1000);
				}
				catch (Exception e)
				{
					strLog = "Exception in ->MessageListener [run()]";
					logger.error(strLog);
				}
			}
		}

		public void dbProcess(Hashtable htDB)
		{
			if ( (sMsgBuff.toString().length()) > 20000)
			{
			  if(ClassMain.callableStmt!=null)
                            {
	                          callDBProcedure(sMsgBuff.toString(),cnt);
                            }

			}
			
		} // dbProcess Ends here

		public void callDBProcedure(String sRetMsg,int cnt)
		{
			try
			{
				sRetMsg ="MSGTYP=MSG;MZTYP=EBA;SXX=ABC;n=4586;i=26;Si=1;s=1;";
				if(ClassMain.getXXXStatus().equals("DBDN"))
                                 	return;
                                   ClassMain.callableStmt.setString(1,sRetMsg);
                                   ClassMain.callableStmt.registerOutParameter(2,java.sql.Types.VARCHAR);
                                   ClassMain.callableStmt.execute();
                                   ClassMain.con.commit();
                                  sRetVal  = ClassMain.callableStmt.getString(2);
			}catch (Exception e)
			{
				strLog = "Exception in ->MessageListener [run()]";
				logger.error(strLog);
			}
		} // callDBProcedure ends here
	} // Message Listener Theread ends here
} // MainClass Ends Here

Quick suggestions will be appreciated.
Regards,