ORA-01786: FOR UPDATE 구는 사용할 수 없습니다

실행 쿼리

 

select
      max(nvl(SEQ_NO,0)) SEQ_NO
  from LAC_COLLATERAL_INOUT
  where COLLATERAL_NO = '801187336900'
  and   BRANCH_ID = '8011'
  for update nowait

 

 

Caused by: java.sql.SQLException: ORA-01786: FOR UPDATE 구는 사용할 수 없습니다

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)

        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
        at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
        at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:124)

 

 

==> 컬럼에만 for update 할 수 있다..