oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Employees.EMPLOYEE_ID, Employees.FIRST_NAME, Employees.LAST_NAME, Employees.EMAIL, Employees.PHONE_NUMBER, Employees.HIRE_DATE, Employees.JOB_ID, Employees.SALARY, Employees.COMMISSION_PCT, Employees.MANAGER_ID, Employees.DEPARTMENT_ID FROM EMPLOYEES Employees WHERE (Employees.EMPLOYEE_ID = :1)

blogspot.nl | 5 months ago
  1. 0

    Andrejus Baranovskis Blog: LOV in Find Mode - Workaround for JDeveloper 11g TP4

    blogspot.com | 1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Employees.EMPLOYEE_ID, Employees.FIRST_NAME, Employees.LAST_NAME, Employees.EMAIL, Employees.PHONE_NUMBER, Employees.HIRE_DATE, Employees.JOB_ID, Employees.SALARY, Employees.COMMISSION_PCT, Employees.MANAGER_ID, Employees.DEPARTMENT_ID FROM EMPLOYEES Employees WHERE (Employees.EMPLOYEE_ID = :1)
  2. 0

    Andrejus Baranovskis Blog: LOV in Find Mode - Workaround for JDeveloper 11g TP4

    blogspot.nl | 5 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Employees.EMPLOYEE_ID, Employees.FIRST_NAME, Employees.LAST_NAME, Employees.EMAIL, Employees.PHONE_NUMBER, Employees.HIRE_DATE, Employees.JOB_ID, Employees.SALARY, Employees.COMMISSION_PCT, Employees.MANAGER_ID, Employees.DEPARTMENT_ID FROM EMPLOYEES Employees WHERE (Employees.EMPLOYEE_ID = :1)
  3. 0

    oracle.jbo.SQLStmtException: JBO-27122:  On  ViewLink traversal

    Oracle Community | 1 decade ago | 336358
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PerEo.PERIDN, PerEo.NATOFPER, PerEo.PERSTAT, PerEo.PERSTATCHGD FROM PER PerEo WHERE (AliasEo.PERIDN = ?)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JBO-27122: SQL error during statement preparation in OAS 10.1.3.4

    Oracle Community | 6 years ago | 788094
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select user_id user_id from apps.fnd_user where user_name =:SSOUse rName
  6. 0

    SQL View Objects - setWhereClause()

    Oracle Community | 1 decade ago | 405015
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct dept from dept where dept!='*****' and inst=:1 and guide_yr=:2

    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 Employees.EMPLOYEE_ID, Employees.FIRST_NAME, Employees.LAST_NAME, Employees.EMAIL, Employees.PHONE_NUMBER, Employees.HIRE_DATE, Employees.JOB_ID, Employees.SALARY, Employees.COMMISSION_PCT, Employees.MANAGER_ID, Employees.DEPARTMENT_ID FROM EMPLOYEES Employees WHERE (Employees.EMPLOYEE_ID = :1)

      at oracle.jbo.server.QueryCollection.buildResultSet()
    2. oracle.jbo.server
      ViewRowSetImpl.executeQueryForMasters
      1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1015)
      2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:762)
      3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:5681)
      4. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1005)
      5. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1162)
      5 frames