Skip to content

PLSQL Record type support for associative arrays #275

Open
@gpgpublickey

Description

@gpgpublickey

In the following scenario:

Stored procedures or functions trying to pass table valued parameters / associative arrays / PL/SQL Index-By Tables are not supporting the PLSQL RECORD type, many applications use this strategy to use multidimensional arrays, currently the ODP.NET Core is not able to work with this kind of associative arrays.

Real world problem:
Use plsql records in combination of associative arrays is really often common strategy used in PLSQL to handle data, so each time you found something like this (and is very common to found) you will need to write wrappers into db or modify existing sp's or functions (something that is not always possible depending on project constraints)

Is there any expected date to implement the support for RECORDS or any well known workaround to make possible use ODP.NET Core in this scenario?

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions