My Oracle Support Banner

ORA-22816: Unsupported Feature With RETURNING CLAUSE when ResultSet.insertRow() Is Executed (Doc ID 2246780.1)

Last updated on MAY 08, 2018

Applies to:

JDBC - Version and later
Information in this document applies to any platform.


WebLogic 12.1.3 application using JDBC receives an "ORA-22816: unsupported feature with RETURNING clause" error message when inserting into a view with a trigger on it.
The trigger is defined as "INSTEAD OF INSERT" . The stack trace from the application is below. The application is using a java.sql.ResultSet generated from a java.sql.PreparedStatement and the error is thrown when ResultSet.insertRow() is executed:


java.sql.SQLException: ORA-22816: unsupported feature with RETURNING clause

  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4C8Oall.processError(
  at oracle.jdbc.driver.T4CTTIfun.receive(
  at oracle.jdbc.driver.T4CTTIfun.doRPC(
  at oracle.jdbc.driver.T4C8Oall.doOALL(
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
  at oracle.jdbc.driver.UpdatableResultSet.executeInsertRow(
  at oracle.jdbc.driver.UpdatableResultSet.insertRow(

The issue can be reproduced at will with the following steps:
1. Create view.
2. Create "INSTEAD OF INSERT trigger.
3. Try to perform the insert.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.