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
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

    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

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

    Invalid column index :RTE after adding eo/vo attributes

    Oracle Community | 9 years ago | 593191
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ContactEO.ROW_ID, ContactEO.FST_NAME, ContactEO.LAST_NAME, ContactEO.CELL_PH_NUM, ContactEO.EMAIL_ADDR, ContactEO.FAX_PH_NUM, ContactEO.HOME_PH_NUM, ContactEO.JOB_TITLE, ContactEO.MID_NAME, ContactEO.OWNER_PER_ID, ContactEO.PER_TITLE, ContactEO.WORK_PH_NUM, ContactEO.MODIFICATION_NUM, ContactEO.CREDIT_SCORE, OrgExtEO.NAME, OrgExtEO.ROW_ID AS ROW_ID11, OrgExtEO.MODIFICATION_NUM AS MODIFICATION_NUM1, OrgExtEO.LOC FROM S_PARTY PartyEO, S_CONTACT ContactEO, S_ORG_EXT OrgExtEO, S_PARTY_PER PartyPerEO WHERE (PartyEO.ROW_ID = ContactEO.PAR_ROW_ID) AND ((ContactEO.ROW_ID = PartyPerEO.PERSON_ID(+)) AND (PartyPerEO.PARTY_ID = OrgExtEO.ROW_ID(+)))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 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

    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