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
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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 | 10 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