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

Oracle Community | Sher Ullah Baig | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 4 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
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