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
  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
  2. 0

    Error while tesing a Datasource created from Java function

    Oracle Community | 10 years ago | 666705
    weblogic.xml.query.exceptions.XQueryStaticException: {lib:TestLayer/xfl/library1}protectSSN:1, line 4, column 1: {err}XQ0017: "{lib:TestLayer/xfl/library1}protectSSN": unknown function (or number of arguments (1) is wrong)

    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