java.sql.SQLException: Error reflecting element type for collection type REC_TAB_VAR Analyze the error and correct if possible. Contact oracle support if error is not fixable.

Oracle Community | snvamsi | 5 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    BINDING.JCA-11821 error while importing Stored procedure through DB adapter

    Oracle Community | 5 years ago | snvamsi
    java.sql.SQLException: Error reflecting element type for collection type REC_TAB_VAR Analyze the error and correct if possible. Contact oracle support if error is not fixable.

    Root Cause Analysis

    1. java.sql.SQLException

      Error reflecting element type for collection type REC_TAB_VAR

      at oracle.j2ee.ws.db.sqlrefl.PlsqlTableType.getElemInfo()
    2. oracle.j2ee.ws
      Doit.main
      1. oracle.j2ee.ws.db.sqlrefl.PlsqlTableType.getElemInfo(PlsqlTableType.java:116)
      2. oracle.j2ee.ws.db.sqlrefl.SqlReflector.addPlsqlDBType(SqlReflector.java:1218)
      3. oracle.j2ee.ws.db.sqlrefl.SqlReflector.addPlsqlDBType(SqlReflector.java:1020)
      4. oracle.j2ee.ws.db.sqlrefl.SqlTypeWithMethods.reflectMethods(SqlTypeWithMethods.java:181)
      5. oracle.j2ee.ws.db.sqlrefl.SqlTypeWithMethods.getDeclaredMethods(SqlTypeWithMethods.java:35)
      6. oracle.j2ee.ws.db.publish.JavaPublisher.generateWrapperName(JavaPublisher.java:937)
      7. oracle.j2ee.ws.db.DoitImpl.mainSql(DoitImpl.java:352)
      8. oracle.j2ee.ws.db.DoitImpl.main(DoitImpl.java:98)
      9. oracle.j2ee.ws.db.Doit.main(Doit.java:37)
      9 frames
    3. oracle.tip.adapter
      JPublisher.findWrapperProcedureName
      1. oracle.tip.adapter.db.sp.xsd.oracle.JPublisher.findWrapperProcedureName(JPublisher.java:213)
      1 frame
    4. oracle.tip.tools
      AbstractStoredProcPage$1.actionPerformed
      1. oracle.tip.tools.ide.adapters.designtime.adapter.db.sp.ProcedureObject.setWrapperInfo(ProcedureObject.java:256)
      2. oracle.tip.tools.ide.adapters.designtime.adapter.db.sp.oracle.DBAdapterStoredProcPage.loadProcedureBrowseDialog(DBAdapterStoredProcPage.java:213)
      3. oracle.tip.tools.ide.adapters.designtime.adapter.db.sp.AbstractStoredProcPage.browseProcButton_actionPerformed(AbstractStoredProcPage.java:369)
      4. oracle.tip.tools.ide.adapters.designtime.adapter.db.sp.AbstractStoredProcPage$1.actionPerformed(AbstractStoredProcPage.java:197)
      4 frames
    5. Java RT
      Dialog.setVisible
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      2. javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
      6. java.awt.Component.processMouseEvent(Component.java:6267)
      7. javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      8. java.awt.Component.processEvent(Component.java:6032)
      9. java.awt.Container.processEvent(Container.java:2041)
      10. java.awt.Component.dispatchEventImpl(Component.java:4630)
      11. java.awt.Container.dispatchEventImpl(Container.java:2099)
      12. java.awt.Component.dispatchEvent(Component.java:4460)
      13. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
      14. java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
      15. java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
      16. java.awt.Container.dispatchEventImpl(Container.java:2085)
      17. java.awt.Window.dispatchEventImpl(Window.java:2478)
      18. java.awt.Component.dispatchEvent(Component.java:4460)
      19. java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
      20. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      21. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      22. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
      23. java.awt.Dialog$1.run(Dialog.java:1046)
      24. java.awt.Dialog$3.run(Dialog.java:1098)
      25. java.security.AccessController.doPrivileged(Native Method)
      26. java.awt.Dialog.show(Dialog.java:1096)
      27. java.awt.Component.show(Component.java:1563)
      28. java.awt.Component.setVisible(Component.java:1515)
      29. java.awt.Window.setVisible(Window.java:842)
      30. java.awt.Dialog.setVisible(Dialog.java:986)
      30 frames
    6. oracle.bali.ewt
      WizardDialog.runDialog
      1. oracle.bali.ewt.wizard.WizardDialog.runDialog(WizardDialog.java:382)
      2. oracle.bali.ewt.wizard.WizardDialog.runDialog(WizardDialog.java:298)
      2 frames
    7. oracle.tip.tools
      DefaultGraphPaneDropTargetListener.drop
      1. oracle.tip.tools.ide.adapters.designtime.adapter.techAdapterWizard.display(techAdapterWizard.java:364)
      2. oracle.tip.tools.ide.adapters.designtime.adapter.DbScaEndpointImpl.createImplementation(DbScaEndpointImpl.java:86)
      3. oracle.tip.tools.ide.bpel.v1.plugins.plugins.adapterservice.plugin.configurators.AdapterSvcConfigurator.display(AdapterSvcConfigurator.java:71)
      4. oracle.tip.tools.ide.bpel.v1.plugins.plugins.adapterservice.plugin.AdapterDNDDropHandler.handleScaEndpoint(AdapterDNDDropHandler.java:110)
      5. oracle.tip.tools.ide.bpel.v1.plugins.plugins.adapterservice.plugin.AdapterDNDDropHandler.handleDrop(AdapterDNDDropHandler.java:69)
      6. oracle.tip.tools.ide.common.graph.view.DefaultGraphPaneDropTargetListener.routeToDropHandler(DefaultGraphPaneDropTargetListener.java:277)
      7. oracle.tip.tools.ide.common.graph.view.DefaultGraphPaneDropTargetListener.handleDrop(DefaultGraphPaneDropTargetListener.java:252)
      8. oracle.tip.tools.ide.bpel.v1.designer.graph.dnd.BPELGraphPaneDropTargetListener.handleDrop(BPELGraphPaneDropTargetListener.java:268)
      9. oracle.tip.tools.ide.common.graph.view.DefaultGraphPaneDropTargetListener.drop(DefaultGraphPaneDropTargetListener.java:359)
      9 frames
    8. Java RT
      EventDispatchThread.run
      1. java.awt.dnd.DropTarget.drop(DropTarget.java:434)
      2. sun.awt.dnd.SunDropTargetContextPeer.processDropMessage(SunDropTargetContextPeer.java:519)
      3. sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchDropEvent(SunDropTargetContextPeer.java:832)
      4. sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchEvent(SunDropTargetContextPeer.java:756)
      5. sun.awt.dnd.SunDropTargetEvent.dispatch(SunDropTargetEvent.java:30)
      6. java.awt.Component.dispatchEventImpl(Component.java:4487)
      7. java.awt.Container.dispatchEventImpl(Container.java:2099)
      8. java.awt.Component.dispatchEvent(Component.java:4460)
      9. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
      10. java.awt.LightweightDispatcher.processDropTargetEvent(Container.java:4312)
      11. java.awt.LightweightDispatcher.dispatchEvent(Container.java:4163)
      12. java.awt.Container.dispatchEventImpl(Container.java:2085)
      13. java.awt.Window.dispatchEventImpl(Window.java:2478)
      14. java.awt.Component.dispatchEvent(Component.java:4460)
      15. java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
      16. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      17. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      18. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
      19. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
      20. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
      21. java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
      21 frames