Skip to content

Add ARRAY parameter type support #3

@dmvolodin

Description

@dmvolodin

Consider we have array type in DB. For example nested table in oracle:
create type number_table as table of number;
and function which returns number_table:

    function get_array return NUMBER_TABLE is
    begin
        return NUMBER_TABLE(1,2,3);
    end;

We can execute this function in pure JDBC like that:

        var call = connection.prepareCall("{? = call get_array}");
        call.registerOutParameter(1, Types.ARRAY, "NUMBER_TABLE");// 3rd parameter not used in morejdbc for now
        call.execute();

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions