Class OracleReturning

java.lang.Object

org.jdbi.v3.oracle12.OracleReturning

@Beta
public class OracleReturning
extends Object

Returns a ResultBearing from Oracle's "DML Returning" features introduced in 10.2. To use, add a returnParameters() customizer to the statement and register with one or more return parameters. Then execute the statement with returningDml() result producer:

List<Integer> ids = handle.createUpdate("insert into something (id, name) values (17, 'Brian') returning id into ?")
    .addCustomizer(OracleReturning.returnParameters().register(0, OracleTypes.INTEGER))
    .execute(OracleReturning.returningDml())
    .mapTo(int.class)
    .list();

assertThat(ids).containsExactly(17);

This class still is beta, and may be changed incompatibly or removed at any time.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	OracleReturning.ReturnParameters

Method Summary

Modifier and Type	Method	Description
static ResultProducer<ResultBearing>	returningDml()	Result producer that returns a ResultBearing over the statement "DML returning" parameters.
static OracleReturning.ReturnParameters	returnParameters()

Methods inherited from class Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

returnParameters

public static OracleReturning.ReturnParameters returnParameters()

returningDml

public static ResultProducer<ResultBearing> returningDml()

Result producer that returns a ResultBearing over the statement "DML returning" parameters. Used in conjunction with returnParameters() to register return parameters.

Returns:

ResultBearing of returned columns.

See Also:

• OraclePreparedStatement.getReturnResultSet()