java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction

Oracle Community | 807581 | 1 decade ago
  1. 0

    SET TRANSACTION must be first statement of transaction

    Oracle Community | 1 decade ago | 807581
    java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction
  2. 0

    When do connections from the connection poll get released?

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction
  3. 0

    java.sql.SQLException: ORA-01453: SET TRANSACTION

    Oracle Community | 10 years ago | 551398
    java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Stored Procedure

    Google Groups | 1 decade ago | ksenji
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00905: object KSENJI.KSENJI is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  6. 0

    SQL command not properly ended (in Oracle)

    Google Groups | 2 decades ago | Teresa Redmond
    java.sql.SQLException: ORA-00933: SQL command not properly ended

    26 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. java.sql.SQLException

      ORA-01453: SET TRANSACTION must be first statement of transaction

      at oracle.jdbc.dbaccess.DBError.throwSqlException()
    2. oracle.jdbc.dbaccess
      DBError.throwSqlException
      1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
      1 frame
    3. oracle.jdbc.ttc7
      TTC7Protocol.parseExecuteFetch
      1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
      2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
      3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
      4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
      4 frames
    4. Oracle jdbc
      OracleConnection.setTransactionIsolation
      1. oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
      2. oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
      3. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
      4. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:737)
      5. oracle.jdbc.driver.OracleConnection.setTransactionIsolation(OracleConnection.java:1081)
      5 frames
    5. Connectors Runtime
      Jdbc20XaAllocator$ConnectionWrapper.setTransactionIsolation
      1. com.sun.enterprise.resource.Jdbc20XaAllocator$ConnectionWrapper.setTransactionIsolation(Jdbc20XaAllocator.java:196)
      1 frame