This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes Problem while accesing collection from stored procedure using Oracle10g Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem while accesing collection from stored procedure using Oracle10g" Watch "Problem while accesing collection from stored procedure using Oracle10g" New topic
Author

Problem while accesing collection from stored procedure using Oracle10g

phani babu
Greenhorn

Joined: May 16, 2006
Posts: 8
java.sql.SQLException: Internal Error
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:208)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.initCollElemTypeName(OracleT
ypeCOLLECTION.java:1074)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.getAttributeType(OracleTypeC
OLLECTION.java:1107)
at oracle.jdbc.oracore.OracleNamedType.getFullName(OracleNamedType.java:
81)
at oracle.jdbc.oracore.OracleNamedType.getFullName(OracleNamedType.java:
68)
at oracle.sql.TypeDescriptor.initSQLName(TypeDescriptor.java:238)
at oracle.sql.TypeDescriptor.getName(TypeDescriptor.java:199)
at oracle.sql.StructDescriptor.getClass(StructDescriptor.java:1105)
at oracle.sql.STRUCT.toJdbc(STRUCT.java:575)
at oracle.jdbc.oracore.OracleTypeUPT.unpickle81UPT(OracleTypeUPT.java:50
2)
at oracle.jdbc.oracore.OracleTypeUPT.unpickle81rec(OracleTypeUPT.java:45
6)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81ImgBodyElements(Or
acleTypeCOLLECTION.java:1011)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81ImgBody(OracleType
COLLECTION.java:952)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unpickle81(OracleTypeCOLLECT
ION.java:764)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unlinearizeInternal(OracleTy
peCOLLECTION.java:243)
at oracle.jdbc.oracore.OracleTypeCOLLECTION.unlinearize(OracleTypeCOLLEC
TION.java:217)
at oracle.sql.ArrayDescriptor.toJavaArray(ArrayDescriptor.java:891)
at oracle.sql.ARRAY.getArray(ARRAY.java:315)
at weblogic.jdbc.wrapper.Array_oracle_sql_ARRAY.getArray(Unknown Source)

at com.bt.ngn.dao.InventoryDao.searchInventory(Unknown Source)
at com.bt.ngn.ejb.TAPSLBean.searchInventory(Unknown Source)
at com.bt.ngn.ejb.TAPSLBean_lljdz4_EOImpl.searchInventory(TAPSLBean_lljd
z4_EOImpl.java:670)
at com.bt.ngn.ejb.TAPSLBean_lljdz4_EOImpl_CBV.searchInventory(Unknown So
urce)
at com.bt.ngn.util.TAPDelegate.searchInventory(Unknown Source)
at com.bt.ngn.action.LoadSearchInventory.execute(Unknown Source)
at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:480)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:142
0)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:520)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run
(ServletStubImpl.java:996)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run(WebAppServletContext.java:6452)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate
dSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:
118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:3661)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:2630)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
root; 2007-09-08 12:04:54,824; ERROR; [TAPDao]; SQLException in getSessionHistor
yDetails (TAPSLDao) :Internal Error
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at java.util.ArrayList.RangeCheck(ArrayList.java:507)
at java.util.ArrayList.get(ArrayList.java:324)
at com.bt.ngn.action.LoadSearchInventory.execute(Unknown Source)
at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:480)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:142
0)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:520)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run
(ServletStubImpl.java:996)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run(WebAppServletContext.java:6452)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate
dSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:
118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:3661)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:2630)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
Srikanth Basa
Ranch Hand

Joined: Jun 06, 2005
Posts: 241
Hard to say without looking at your code
 
GeeCON Prague 2014
 
subject: Problem while accesing collection from stored procedure using Oracle10g