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

Oracle Community | 805279 | 6 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

    Error in the Logical dataservice for ODSI

    Oracle Community | 6 years ago | 805279
    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

    Root Cause Analysis

    1. 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()
    2. weblogic.xml.query
      XDBCConnection.prepareStatement
      1. weblogic.xml.query.compiler.FirstOrderExpression.codeGenImpl(FirstOrderExpression.java:539)
      2. weblogic.xml.query.compiler.Expression.codeGenCommonImpl(Expression.java:553)
      3. weblogic.xml.query.compiler.FirstOrderExpression.codeGenImpl(FirstOrderExpression.java:503)
      4. weblogic.xml.query.compiler.Expression.codeGenCommonImpl(Expression.java:553)
      5. weblogic.xml.query.compiler.QueryAssassinExpression.codeGenImpl(QueryAssassinExpression.java:61)
      6. weblogic.xml.query.compiler.Expression.codeGenCommonImpl(Expression.java:553)
      7. weblogic.xml.query.compiler.Expression.codeGen(Expression.java:545)
      8. weblogic.xml.query.xdbcimpl.XqueryStatement.codeGen(XqueryStatement.java:314)
      9. weblogic.xml.query.xdbcimpl.AbstractStatement.compile(AbstractStatement.java:285)
      10. weblogic.xml.query.xdbcimpl.AbstractStatement.prepare(AbstractStatement.java:253)
      11. weblogic.xml.query.xdbcimpl.XQueryPreparedStatementImpl.init(XQueryPreparedStatementImpl.java:77)
      12. weblogic.xml.query.xdbcimpl.XQueryPreparedStatementImpl.<init>(XQueryPreparedStatementImpl.java:64)
      13. weblogic.xml.query.xdbcimpl.XDBCConnection.prepareStatement(XDBCConnection.java:117)
      13 frames
    3. com.bea.ld
      Server_ydm4ie_EOImpl_WLSkel.invoke
      1. com.bea.ld.server.XQuery.createPrototype(XQuery.java:64)
      2. com.bea.ld.server.XQuery.<init>(XQuery.java:57)
      3. com.bea.ld.server.XStatement.newInstance(XStatement.java:46)
      4. com.bea.ld.server.QueryEngine.makeXQueryPlan(QueryEngine.java:79)
      5. com.bea.ld.server.QueryEngine.makePlan(QueryEngine.java:56)
      6. com.bea.ld.EJBRequestHandler.invokeQueryInternal(EJBRequestHandler.java:544)
      7. com.bea.ld.EJBRequestHandler.invokeOperationInternal(EJBRequestHandler.java:478)
      8. com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:323)
      9. com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84)
      10. com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:496)
      11. com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)
      11 frames
    4. weblogic.rmi.internal
      BasicServerRef.invoke
      1. weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)
      1 frame
    5. weblogic.rmi.cluster
      ClusterableServerRef.invoke
      1. weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
      1 frame
    6. weblogic.rmi.internal
      BasicServerRef$1.run
      1. weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:477)
      1 frame
    7. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
      1 frame
    8. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(Unknown Source)
      1 frame
    9. weblogic.rmi.internal
      WLSExecuteRequest.run
      1. weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473)
      2. weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
      2 frames
    10. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
      2 frames