java.sql.SQLException: invalid name pattern: DEV_BIACOMP.FND_TABLE_OF_VARCHAR2_120

Oracle Community | Sher Ullah Baig | 3 years ago
  1. 0

    BI Configuration manger Error while mapping Workforce Event Reason Combination → Workforce Event Detail

    Oracle Community | 3 years ago | Sher Ullah Baig
    java.sql.SQLException: invalid name pattern: DEV_BIACOMP.FND_TABLE_OF_VARCHAR2_120
  2. 0

    Help me on below error

    Oracle Community | 3 years ago | Jyothi.mj
    java.sql.SQLException: Invalid column index
  3. 0

    How to handle callableStatement.registerOutParameter(1, java.sql.Types.BOOLEAN);

    Stack Overflow | 3 years ago | fledglingCoder
    java.sql.SQLException: Invalid column type: 16
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Why does JDBC not support Oracle Boolean type

    Stack Overflow | 2 years ago | Twister
    java.sql.SQLException: Invalid column type: 16
  6. 0

    SQL state [99999]; error code [17004]; Invalid column type: 1111 With Spring SimpleJdbcCall

    Stack Overflow | 4 years ago | Krushna
    org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{call VSC.GET_ALL_SYSTEM_USERS(?, ?, ?, ?)}]; SQL state [99999]; error code [17004]; Invalid column type: 1111; nested exception is java.sql.SQLException: Invalid column type: 1111

  1. mellson 2 times, last 5 months ago
1 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    invalid name pattern: DEV_BIACOMP.FND_TABLE_OF_VARCHAR2_120

    at oracle.jdbc.oracore.OracleTypeADT.initMetadata()
  2. Oracle jdbc
    OracleCallableStatementWrapper.registerOutParameter
    1. oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:599)
    2. oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:506)
    3. oracle.sql.ArrayDescriptor.initPickler(ArrayDescriptor.java:2152)
    4. oracle.sql.ArrayDescriptor.<init>(ArrayDescriptor.java:260)
    5. oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:167)
    6. oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:135)
    7. oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:117)
    8. oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:75)
    9. oracle.jdbc.driver.NamedTypeAccessor.otypeFromName(NamedTypeAccessor.java:89)
    10. oracle.jdbc.driver.TypeAccessor.initMetadata(TypeAccessor.java:96)
    11. oracle.jdbc.driver.T4CCallableStatement.allocateAccessor(T4CCallableStatement.java:759)
    12. oracle.jdbc.driver.OracleCallableStatement.registerOutParameterInternal(OracleCallableStatement.java:196)
    13. oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:258)
    14. oracle.jdbc.driver.OracleCallableStatementWrapper.registerOutParameter(OracleCallableStatementWrapper.java:1783)
    14 frames
  3. weblogic.jdbc.wrapper
    CallableStatement_oracle_jdbc_driver_OracleCallableStatementWrapper.registerOutParameter
    1. weblogic.jdbc.wrapper.CallableStatement_oracle_jdbc_driver_OracleCallableStatementWrapper.registerOutParameter(Unknown Source)
    1 frame
  4. oracle.apps.fnd
    OAApplicationModuleImpl.prepareSession
    1. oracle.apps.fnd.applcore.common.ApplSession.getRoles(ApplSession.java:706)
    2. oracle.apps.fnd.applcore.common.ApplSession.attachSession(ApplSession.java:2436)
    3. oracle.apps.fnd.applcore.oaext.model.OAApplicationModuleImpl.prepareSession(OAApplicationModuleImpl.java:979)
    3 frames
  5. oracle.jbo.server
    ApplicationModuleImpl.doPoolMessage
    1. oracle.jbo.server.ApplicationModuleImpl.prepareSession(ApplicationModuleImpl.java:6918)
    2. oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:182)
    3. oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9316)
    3 frames
  6. oracle.jbo.common
    SessionCookieImpl.useApplicationModule
    1. oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4530)
    2. oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2460)
    3. oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2270)
    4. oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3169)
    5. oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:592)
    5 frames
  7. oracle.jbo.http
    HttpSessionCookieImpl.useApplicationModule
    1. oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:234)
    1 frame
  8. oracle.jbo.common
    SessionCookieImpl.useApplicationModule
    1. oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:525)
    2. oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:520)
    2 frames
  9. oracle.jbo.client
    Configuration.createRootApplicationModule
    1. oracle.jbo.client.Configuration.getApplicationModule(Configuration.java:1609)
    2. oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1514)
    3. oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1485)
    3 frames
  10. oracle.apps.fnd
    ManageSandboxesBean.isRenderFlag
    1. oracle.apps.fnd.applcore.Profile.getNonBindingContainerProfileService(Profile.java:341)
    2. oracle.apps.fnd.applcore.Profile.getService(Profile.java:318)
    3. oracle.apps.fnd.applcore.Profile.get(Profile.java:223)
    4. oracle.apps.fnd.applcore.common.ApplSessionUtil.getProfileValue(ApplSessionUtil.java:3295)
    5. oracle.apps.fnd.applcore.patterns.uishell.internal.ExternalServicesAdapter.getProfileValue(ExternalServicesAdapter.java:385)
    6. oracle.apps.fnd.applcore.patterns.uishell.ui.bean.ManageSandboxesBean.getSandboxCheckActive(ManageSandboxesBean.java:314)
    7. oracle.apps.fnd.applcore.patterns.uishell.ui.bean.ManageSandboxesBean.isRenderFlag(ManageSandboxesBean.java:1248)
    7 frames
  11. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor912.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  12. EL
    BeanELResolver.getValue
    1. javax.el.BeanELResolver.getValue(BeanELResolver.java:293)
    1 frame
  13. JSF
    DemuxCompositeELResolver.getValue
    1. com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:173)
    2. com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:200)
    2 frames
  14. EL
    ValueExpressionImpl.getValue
    1. com.sun.el.parser.AstValue.getValue(AstValue.java:138)
    2. com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:206)
    2 frames
  15. Apache MyFaces Trinidad API
    UIXComponent.processFlattenedChildren
    1. org.apache.myfaces.trinidad.bean.FacesBeanImpl.getProperty(FacesBeanImpl.java:68)
    2. org.apache.myfaces.trinidad.component.UIXComponentBase.getBooleanProperty(UIXComponentBase.java:1363)
    3. org.apache.myfaces.trinidad.component.UIXComponentBase.isRendered(UIXComponentBase.java:496)
    4. org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:154)
    5. org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:290)
    6. org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:213)
    6 frames
  16. oracle.adfinternal.view
    PanelGroupLayoutRenderer.encodeAll
    1. oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer.encodeAll(PanelGroupLayoutRenderer.java:343)
    1 frame
  17. oracle.adf.view
    RichRenderer.encodeAll
    1. oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1432)
    1 frame
  18. Apache MyFaces Trinidad API
    UIXComponentBase.encodeEnd
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:358)
    2. org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:840)
    2 frames
  19. JavaEE 7
    UIComponent.encodeAll
    1. javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
    1 frame
  20. Apache MyFaces Trinidad API
    CoreRenderer.encodeChild
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:422)
    1 frame
  21. oracle.adf.view
    RichRenderer.encodeChild
    1. oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2788)
    1 frame
  22. oracle.adfinternal.view
    PanelBorderLayoutRenderer.encodeAll
    1. oracle.adfinternal.view.faces.renderkit.rich.PanelBorderLayoutRenderer.renderSideFacet(PanelBorderLayoutRenderer.java:316)
    2. oracle.adfinternal.view.faces.renderkit.rich.PanelBorderLayoutRenderer._renderRightFacets(PanelBorderLayoutRenderer.java:384)
    3. oracle.adfinternal.view.faces.renderkit.rich.PanelBorderLayoutRenderer._encodeAllWithSideFacets(PanelBorderLayoutRenderer.java:227)
    4. oracle.adfinternal.view.faces.renderkit.rich.PanelBorderLayoutRenderer.encodeAll(PanelBorderLayoutRenderer.java:83)
    4 frames
  23. oracle.adf.view
    RichRenderer.encodeAll
    1. oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1432)
    1 frame
  24. Apache MyFaces Trinidad API
    UIXComponentBase.encodeEnd
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:358)
    2. org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:840)
    2 frames
  25. JavaEE 7
    UIComponent.encodeAll
    1. javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
    1 frame
  26. Apache MyFaces Trinidad API
    CoreRenderer.encodeChild
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:422)
    1 frame
  27. oracle.adf.view
    RichRenderer.encodeChild
    1. oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2788)
    1 frame
  28. oracle.adfinternal.view
    PanelGroupLayoutRenderer$EncoderCallback.processComponent
    1. oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer._encodeChild(PanelGroupLayoutRenderer.java:432)
    2. oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer.access$300(PanelGroupLayoutRenderer.java:30)
    3. oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer$EncoderCallback.processComponent(PanelGroupLayoutRenderer.java:682)
    4. oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer$EncoderCallback.processComponent(PanelGroupLayoutRenderer.java:601)
    4 frames
  29. Apache MyFaces Trinidad API
    UIXComponent.encodeFlattenedChildren
    1. org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:170)
    2. org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:290)
    3. org.apache.myfaces.trinidad.component.UIXComponent.encodeFlattenedChildren(UIXComponent.java:255)
    3 frames
  30. oracle.adfinternal.view
    PanelGroupLayoutRenderer.encodeAll
    1. oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer.encodeAll(PanelGroupLayoutRenderer.java:358)
    1 frame
  31. oracle.adf.view
    RichRenderer.encodeAll
    1. oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1432)
    1 frame
  32. Apache MyFaces Trinidad API
    UIXComponentBase.encodeEnd
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:358)
    2. org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:840)
    2 frames
  33. JavaEE 7
    UIComponent.encodeAll
    1. javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
    1 frame
  34. Apache MyFaces Trinidad API
    CoreRenderer.encodeChild
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:422)
    1 frame
  35. oracle.adf.view
    RichRenderer.encodeChild
    1. oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2788)
    1 frame
  36. oracle.adfinternal.view
    PanelStretchLayoutRenderer.encodeAll
    1. oracle.adfinternal.view.faces.renderkit.rich.PanelStretchLayoutRenderer.encodeTopFacet(PanelStretchLayoutRenderer.java:781)
    2. oracle.adfinternal.view.faces.renderkit.rich.PanelStretchLayoutRenderer._encodeHorizontalPane(PanelStretchLayoutRenderer.java:1255)
    3. oracle.adfinternal.view.faces.renderkit.rich.PanelStretchLayoutRenderer.encodeAll(PanelStretchLayoutRenderer.java:298)
    3 frames
  37. oracle.adf.view
    RichRenderer.encodeAll
    1. oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1432)
    1 frame
  38. Apache MyFaces Trinidad API
    UIXComponentBase.encodeEnd
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:358)
    2. org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:840)
    2 frames
  39. JavaEE 7
    UIComponent.encodeAll
    1. javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
    1 frame
  40. Apache MyFaces Trinidad API
    CoreRenderer.encodeChild
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:422)
    1 frame
  41. oracle.adf.view
    RichRenderer.encodeStretchedChild
    1. oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2788)
    2. oracle.adf.view.rich.render.RichRenderer.encodeStretchedChild(RichRenderer.java:2150)
    2 frames
  42. oracle.adfinternal.view
    PageCustomizableRenderer.encodeAll
    1. oracle.adfinternal.view.page.editor.renderkit.PageCustomizableRenderer.encodeAll(PageCustomizableRenderer.java:330)
    1 frame
  43. oracle.adf.view
    RichRenderer.encodeAll
    1. oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1432)
    1 frame
  44. Apache MyFaces Trinidad API
    UIXComponentBase.encodeEnd
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:358)
    2. org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:840)
    2 frames
  45. JavaEE 7
    UIComponent.encodeAll
    1. javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
    1 frame
  46. Apache MyFaces Trinidad API
    CoreRenderer.encodeChild
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:422)
    1 frame
  47. oracle.adf.view
    RichRenderer.encodeChild
    1. oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2788)
    1 frame
  48. oracle.adfinternal.view
    PanelStretchLayoutRenderer.encodeAll
    1. oracle.adfinternal.view.faces.renderkit.rich.PanelStretchLayoutRenderer.encodeCenterFacet(PanelStretchLayoutRenderer.java:769)
    2. oracle.adfinternal.view.faces.renderkit.rich.PanelStretchLayoutRenderer._encodeCenterPane(PanelStretchLayoutRenderer.java:1146)
    3. oracle.adfinternal.view.faces.renderkit.rich.PanelStretchLayoutRenderer._encodeMiddlePanes(PanelStretchLayoutRenderer.java:348)
    4. oracle.adfinternal.view.faces.renderkit.rich.PanelStretchLayoutRenderer.encodeAll(PanelStretchLayoutRenderer.java:313)
    4 frames
  49. oracle.adf.view
    RichRenderer.encodeAll
    1. oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1432)
    1 frame
  50. Apache MyFaces Trinidad API
    UIXComponentBase.encodeEnd
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:358)
    2. org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:840)
    2 frames
  51. JavaEE 7
    UIComponent.encodeAll
    1. javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
    1 frame
  52. Apache MyFaces Trinidad API
    CoreRenderer.encodeChild
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:422)
    1 frame
  53. oracle.adf.view
    RichRenderer.encodeChild
    1. oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2788)
    1 frame
  54. Apache MyFaces Trinidad API
    CoreRenderer.encodeAllChildren
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeAllChildren(CoreRenderer.java:438)
    1 frame
  55. oracle.adfinternal.view
    FormRenderer.encodeAll
    1. oracle.adfinternal.view.faces.renderkit.rich.FormRenderer.encodeAll(FormRenderer.java:220)
    1 frame
  56. oracle.adf.view
    RichRenderer.encodeAll
    1. oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1432)
    1 frame
  57. Apache MyFaces Trinidad API
    UIXComponentBase.encodeEnd
    1. org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:358)
    2. org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:840)
    2 frames
  58. JavaEE 7
    UIComponent.encodeAll
    1. javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
    1 frame