• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Internal Error:Invalid index for data access

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 1087
Oracle Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
  • post your code, with the signature of your stored procedure.
  • post the StackTrace if any




  • Shailesh
     
    Greenhorn
    Posts: 1
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    anyone got an answer to this problem

    Internal error: invalid index for data access

    calling a stored procedure from a JSP
     
    author & internet detective
    Posts: 41860
    908
    Eclipse IDE VI Editor Java
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    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.
     
    Greenhorn
    Posts: 3
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator

    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
    Greenhorn
    Posts: 3
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator

    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)


     
    Bartender
    Posts: 2661
    19
    Netbeans IDE C++ Linux
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Hi Sameer,

    Its Production issue. Urgent please

    Sorry. that is a non-java related issue that we can't fix
    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
    Greenhorn
    Posts: 3
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator

    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))


    Quick suggestions will be appreciated.
    Regards,

    reply
      Bookmark Topic Watch Topic
    • New Topic