oracle / oracle-r2dbc

R2DBC Driver for Oracle Database
https://oracle.com
Other
197 stars 40 forks source link

Array Types #101

Closed Michael-A-McMahon closed 1 year ago

Michael-A-McMahon commented 1 year ago

This branch adds support for ARRAY types in Oracle Database.

The bind methods of Statement may now be used to bind Java arrays to the ARRAY type. Likewise, the get methods of Readable may now be used to get ARRAY values as Java arrays.

Oracle Database only supports ARRAY as a user defined type. In order to bind a value to an ARRAY, the name of the user defined type must be known to the driver. Oracle R2DBC will extend the R2DBC SPI with a new Type that represents a named ARRAY type: oracle.r2dbc.OracleR2DBCTypes.ArrayType.

Instances of ArrayType must be used to create io.r2dbc.spi.Parameter objects that bind Java arrays to ARRAY values.

See changes in the README.md for usage examples.