input binding with table of udt

[kumark92]

I'm trying to bind the input parameters of table of udt using OracleR2dbcTypes.arrayType("ADDRESS_TABLE") but getting error ORA-17059: Failed to convert internal representation: {CITY=Newyork}.
Does this support binding the table of udt

and I have this in Db
CREATE OR REPLACE TYPE ADDRESS_TYPE AS OBJECT (
CITY VARCHAR2(60)
);

CREATE OR REPLACE TYPE ADDRESS_TABLE AS TABLE OF ADDRESS_TYPE;

databaseClient.sql("SELECT * FROM TABLE(GET_Persons(:address_in))")
.bind("address_in", Parameters.in(OracleR2dbcTypes.arrayType("ADDRESS_TABLE"), new Object[]{Map.of("CITY", "Newyork")}))
.map((row,meta)) -> {
//process the result
}
.all()
.collectList();

[Michael-A-McMahon]

Thanks for creating this issue @kumark92 !

I think there's a defect in Oracle R2DBC here, because it's not checking for an ARRAY type'd bind that has OBJECT type'd elements. I'm working on a fix, and also seeing if I can find you a workaround for the interim.

I'm hoping to have an update on this in the next few days.