oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PARAMETER_ID PARAMETER_ID, PARAMETER_NAME PARAMETER_NAME, PARAMETER_TYPE_ID PARAMETER_TYPE_ID, COMPLEX_FLAG, IS_CONDITION, IS_NOT_CONDITION FROM VSOE_PARAMETERS_V where (TRUNC(START_DATE)<=TRUNC(SYSDATE) OR START_DATE IS NULL) AND (END_DATE >TRUNC(SYSDATE) OR END_DATE IS NULL)) QRSLT WHERE (upper(QRSLT.PARAMETER_NAME)='CUST FLAG 4') ORDER BY PARAMETER_NAME

Oracle Community | 692402 | 8 years ago
  1. 0

    JBO-27122: SQL error during statement preparation

    Oracle Community | 8 years ago | 692402
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PARAMETER_ID PARAMETER_ID, PARAMETER_NAME PARAMETER_NAME, PARAMETER_TYPE_ID PARAMETER_TYPE_ID, COMPLEX_FLAG, IS_CONDITION, IS_NOT_CONDITION FROM VSOE_PARAMETERS_V where (TRUNC(START_DATE)<=TRUNC(SYSDATE) OR START_DATE IS NULL) AND (END_DATE >TRUNC(SYSDATE) OR END_DATE IS NULL)) QRSLT WHERE (upper(QRSLT.PARAMETER_NAME)='CUST FLAG 4') ORDER BY PARAMETER_NAME
  2. 0

    JBO-27122 SQL error during Statement preparation

    Google Groups | 1 decade ago | Jeff
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Product.APPNAME, Product.PRODID, Product.DESCRIPTION, Product.PRICE, Product.THUMBNAIL, Product.DESCRIPTION_ES, Product.DESCRIPTION_FR FROM ETC.ECOM_PRODUCT Product WHERE (SPECIALCHARGE <> 'Y' OR SPECIALCHARGE IS NULL) AND APPNAME = ? AND ((DISABLED <> 'Y' OR DISABLED IS NULL)) ORDER BY PRODID
  3. 0

    Design Gererator issue

    Oracle Community | 1 decade ago | 437234
    oracle.jbo.SQLStmtException: JBO-27120: SQL error during query execution. State ment: select tab.name tabName , tab.irid tabIrid , tab.table_type tab leType , tab.ivid tabIvid , mti.alias mtiAlias , mde.name mdeName , decode ( ov.state , 'O' , jr_version.get_vlabe l(ov.irid, jr_version.get_original_of_checkout( ov.irid,ov.ivid))||'CO' , 'I' , ov.vlabel , 'N' , '' , '0.0' ) versionLabel from ci_general_modules mde , ci relation definitions tab , ci_module_detail_table_usages mti , ci_m odule_component_inclusions mcn , sdd_object_versions ov where mde.ivid = .ivid and mti.module_unit_reference = mcn.module_component_reference and mti.table_reference = tab.irid and ov.ivid = tab.ivid UNION select tab.na me tabName , tab.irid tabIrid , tab.table_type tableType , tab.iv id tabIvid , mti.alias mtiAlias , mde.name mdeName , decode ( ov.state , 'O' , jr_version.get_vlabel(ov.irid, jr_versio n.get_original_of_checkout( ov.irid,ov.ivid))||'CO' , 'I' , ov.vlabel , 'N' , '' , '0.0' ) versionLabel from ci_general_modules mde , ci_relation_definition s tab , ci_module_detail_table_usages mti , ci_lov_inclusions lvi , sdd_object_versions ov where mde.ivid = :1 and lvi.general_module_ref erence = mde.irid and lvi.parent_ivid = mde.ivid and mti.module_unit_ref erence = lvi.list_of_values_reference and mti.table_reference = tab.irid a nd ov.ivid = tab.ivid order by 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    setWhereClauseParam

    Oracle Community | 9 years ago | BabakSaraie
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT employeeSalary(:empID) as EmpSal FROM DUAL
  6. 0

    [SOLVED]Connecting DB problem

    Oracle Community | 9 years ago | soso_xuc
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT T.FUNCTION_ID FUNCTION_ID, T.FUNCTION_NAME FUNCTION_NAME, T.FUNCTION_URL FUNCTION_URL, T.FUNCTION_PARAMS FUNCTION_PARAMS FROM TASKS.FUNCTIONS T

    1 unregistered visitors
    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. oracle.jbo.SQLStmtException

      JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PARAMETER_ID PARAMETER_ID, PARAMETER_NAME PARAMETER_NAME, PARAMETER_TYPE_ID PARAMETER_TYPE_ID, COMPLEX_FLAG, IS_CONDITION, IS_NOT_CONDITION FROM VSOE_PARAMETERS_V where (TRUNC(START_DATE)<=TRUNC(SYSDATE) OR START_DATE IS NULL) AND (END_DATE >TRUNC(SYSDATE) OR END_DATE IS NULL)) QRSLT WHERE (upper(QRSLT.PARAMETER_NAME)='CUST FLAG 4') ORDER BY PARAMETER_NAME

      at oracle.jbo.server.DBTransactionImpl.createPreparedStatement()
    2. oracle.jbo.server
      ViewObjectImpl.executeQuery
      1. oracle.jbo.server.DBTransactionImpl.createPreparedStatement(DBTransactionImpl.java:3430)
      2. oracle.jbo.server.DBTransactionImpl2.createPreparedStatement(DBTransactionImpl2.java:428)
      3. oracle.jbo.server.DBTransactionImpl.createReUsePreparedStatement(DBTransactionImpl.java:4239)
      4. oracle.jbo.server.ViewObjectImpl.getPreparedStatement(ViewObjectImpl.java:8202)
      5. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:746)
      6. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:666)
      7. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3655)
      8. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:742)
      9. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:891)
      10. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:805)
      11. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:799)
      12. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3575)
      12 frames
    3. com.cisco.vsoe
      GenerateParameterValueCreate.displayAddParamters
      1. com.cisco.vsoe.backing.jsp.rateanalysis.GenerateParameterValueCreate.displayAddParamters(GenerateParameterValueCreate.java:313)
      1 frame
    4. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor321.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:585)
      3 frames
    5. JSF
      ActionListenerImpl.processAction
      1. com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:146)
      2. com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:92)
      2 frames
    6. oracle.adf.view
      UIXCommand.broadcast
      1. oracle.adf.view.faces.component.UIXCommand.broadcast(UIXCommand.java:211)
      1 frame
    7. JavaEE 7
      UIViewRoot.processApplication
      1. javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:287)
      2. javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:401)
      2 frames
    8. JSF
      LifecycleImpl.execute
      1. com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:95)
      2. com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:245)
      3. com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:110)
      3 frames
    9. JavaEE 7
      FacesServlet.service
      1. javax.faces.webapp.FacesServlet.service(FacesServlet.java:213)
      1 frame
    10. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
      1 frame
    11. oracle.adfinternal.view
      AdfFacesFilterImpl.doFilter
      1. oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._invokeDoFilter(AdfFacesFilterImpl.java:228)
      2. oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFacesFilterImpl.java:197)
      3. oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilterImpl.java:123)
      3 frames
    12. oracle.adf.view
      AdfFacesFilter.doFilter
      1. oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:103)
      1 frame
    13. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    14. oracle.adf.model
      ADFBindingFilter.doFilter
      1. oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:162)
      1 frame
    15. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
      1 frame
    16. oracle.adf.model
      ADFBindingFilter.doFilter
      1. oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:162)
      1 frame
    17. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
      1 frame
    18. com.cisco.vsoe
      SessionFilter.doFilter
      1. com.cisco.vsoe.backing.jsp.filter.SessionFilter.doFilter(SessionFilter.java:133)
      1 frame
    19. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:302)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:190)
      6 frames
    20. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    21. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    22. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame