Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 Android Security Essentials Live Lessons this week in the Android 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
 
Don't get me started about those stupid light bulbs.
 
subject: Problem while accesing collection from stored procedure using Oracle10g
 
Similar Threads
JDBC resultset issues with weblogic 8.1.6
error while invoking axis AdminService in weblogic 8.1.3 environment
InitialContext.lookup NamingException
ClassNotFoundException
Problem after Weblogic 8.1 SP2 upgradation to SP4