com.bea.dsp.das.exception.DASException

weblogic.xml.query.exceptions.XQueryStaticException: ld:Logical/REAFirmInfo/sampleTest1.ds, line 13, column 5: {bea-err}FUNC001: "{ld:Physical/sample}get_trade_name": unbound external function. Improper use of the user-defined SQL function {ld:Physical/sample}get_trade_name

Solutions on the web15

  • via Oracle Community by 805279, 10 months ago
    weblogic.xml.query.exceptions.XQueryStaticException: ld:Logical/REAFirmInfo/sampleTest1.ds, line 13, column 5: {bea-err}FUNC001: "{ld:Physical/sample}get_trade_name": unbound external function. Improper use of the user-defined SQL function {ld:Physical/sample}get_trade_name
  • via Oracle Community by 805279, 10 months ago
    weblogic.xml.query.exceptions.XQueryStaticException: ld:Logical/BusinessIDN/BusinessIdn.ds, line 136, column 5: {bea-err}FUNC001: "{ld:Physical/getTradeName}get_tname": unbound external function. Improper use of the user-defined SQL function {ld:Physical/getTradeName}get_tname
  • via Oracle Community by 761210, 10 months ago
    }RDBW0004: Error executing SQL query: [BEA][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PAG_TES' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  • Stack trace

    • com.bea.dsp.das.exception.DASException: weblogic.xml.query.exceptions.XQueryStaticException: ld:Logical/REAFirmInfo/sampleTest1.ds, line 13, column 5: {bea-err}FUNC001: "{ld:Physical/sample}get_trade_name": unbound external function. Improper use of the user-defined SQL function {ld:Physical/sample}get_trade_name at com.bea.dsp.das.ejb.EJBClient.invokeOperation(EJBClient.java:160) at com.bea.dsp.das.DataAccessServiceImpl.invokeOperation(DataAccessServiceImpl.java:171) at com.bea.dsp.das.DataAccessServiceImpl.invoke(DataAccessServiceImpl.java:122) at com.bea.dsp.ide.xquery.views.test.QueryExecutor.invokeFunctionOrProcedure(QueryExecutor.java:113) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.getFunctionExecutionResult(XQueryTestView.java:1041) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.executeFunction(XQueryTestView.java:1176) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.widgetSelectedImpl(XQueryTestView.java:1866) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.access$300(XQueryTestView.java:174) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent$3.run(XQueryTestView.java:1594) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.widgetSelectedBusy(XQueryTestView.java:1597) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.widgetSelected(XQueryTestView.java:1560) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3687) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3298) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447) at org.eclipse.equinox.launcher.Main.run(Main.java:1173) at org.eclipse.equinox.launcher.Main.eclipse_main(Main.java:1148) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.m7.installer.util.NitroxMain$1.run(NitroxMain.java:33) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:199) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160) at java.awt.EventDispatchThread.run(EventDispatchThread.java:121) Caused by: weblogic.xml.query.exceptions.XQueryStaticException: ld:Logical/REAFirmInfo/sampleTest1.ds, line 13, column 5: {bea-err}FUNC001: "{ld:Physical/sample}get_trade_name": unbound external function. Improper use of the user-defined SQL function {ld:Physical/sample}get_trade_name at weblogic.xml.query.compiler.FirstOrderExpression.codeGenImpl(FirstOrderExpression.java:539) at weblogic.xml.query.compiler.Expression.codeGenCommonImpl(Expression.java:553) at weblogic.xml.query.compiler.FirstOrderExpression.codeGenImpl(FirstOrderExpression.java:503) at weblogic.xml.query.compiler.Expression.codeGenCommonImpl(Expression.java:553) at weblogic.xml.query.compiler.QueryAssassinExpression.codeGenImpl(QueryAssassinExpression.java:61) at weblogic.xml.query.compiler.Expression.codeGenCommonImpl(Expression.java:553) at weblogic.xml.query.compiler.Expression.codeGen(Expression.java:545) at weblogic.xml.query.xdbcimpl.XqueryStatement.codeGen(XqueryStatement.java:314) at weblogic.xml.query.xdbcimpl.AbstractStatement.compile(AbstractStatement.java:285) at weblogic.xml.query.xdbcimpl.AbstractStatement.prepare(AbstractStatement.java:253) at weblogic.xml.query.xdbcimpl.XQueryPreparedStatementImpl.init(XQueryPreparedStatementImpl.java:77) at weblogic.xml.query.xdbcimpl.XQueryPreparedStatementImpl.<init>(XQueryPreparedStatementImpl.java:64) at weblogic.xml.query.xdbcimpl.XDBCConnection.prepareStatement(XDBCConnection.java:117) at com.bea.ld.server.XQuery.createPrototype(XQuery.java:64) at com.bea.ld.server.XQuery.<init>(XQuery.java:57) at com.bea.ld.server.XStatement.newInstance(XStatement.java:46) at com.bea.ld.server.QueryEngine.makeXQueryPlan(QueryEngine.java:79) at com.bea.ld.server.QueryEngine.makePlan(QueryEngine.java:56) at com.bea.ld.EJBRequestHandler.invokeQueryInternal(EJBRequestHandler.java:544) at com.bea.ld.EJBRequestHandler.invokeOperationInternal(EJBRequestHandler.java:478) at com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:323) at com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84) at com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:496) at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589) at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230) at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:477) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363) at weblogic.security.service.SecurityManager.runAs(Unknown Source) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473) at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201) at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You are the first who have seen this exception. Write a tip to help other users and build your expert profile.