ORACLE異常：RETURNING子句不支持的功能
獲取序列ID時(shí)出現(xiàn)的異常，檢查oracle數(shù)據(jù)庫表ID字段類型是否為NUMBER類型。如果是long修改為number即可。 有關(guān)number類型：http://www.blogjava.net/caojianhua/archive/2011/01/24/343461.html 嚴(yán)重: null java.sql.SQLException: ORA-22816: RETURNING 子句不支持的功能 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061) at org.iie.dao.impl.OracleGenelDaoImpl.insertDataReturnKeyByReturnInto(OracleGenelDaoImpl.java:160) at org.iie.dao.impl.OracleGenelDaoImpl.main(OracleGenelDaoImpl.java:148)
順便貼出獲取序列號(hào)的方法：
成都創(chuàng)新互聯(lián)公司-專業(yè)網(wǎng)站定制、快速模板網(wǎng)站建設(shè)、高性價(jià)比沐川網(wǎng)站開發(fā)、企業(yè)建站全套包干低至880元,成熟完善的模板庫,直接使用。一站式沐川網(wǎng)站制作公司更省心,省錢,快速模板網(wǎng)站建設(shè)找我們，業(yè)務(wù)覆蓋沐川地區(qū)。費(fèi)用合理售后完善，10多年實(shí)體公司更值得信賴。
public static int insertDataReturnKeyByReturnInto() throws Exception {
Connection conn = GlobalData.getOracleConnection();
String vsql = "insert into xx(id) values(xx_squencee.nextval) returning id into :1";
OraclePreparedStatement pstmt = (OraclePreparedStatement) conn.prepareStatement(vsql);
pstmt.registerReturnParameter(1, Types.BIGINT);
pstmt.executeUpdate();
ResultSet rs = pstmt.getReturnResultSet();
rs.next();
int id = rs.getInt(1);
rs.close();
pstmt.close();
System.out.print("id:" + id);
return id;
}
分享名稱：ORACLE異常：RETURNING子句不支持的功能
瀏覽地址：http://m.jiaotiyi.com/article/pjcejg.html