aspose file tools*
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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem while accesing collection from stored procedure using Oracle10g