Skip to content

0.8.0 breaks Oracle function #203

@jacobat

Description

@jacobat

After upgrading to 0.8.0 we're seeing an error when calling one of our Oracle functions. The function has the signature:

FUNCTION get_customers (customer_id               IN NUMBER,
                        user_id                   IN NUMBER,
                        p_customers_tab           OUT NOCOPY my_package.tab_CustomersType
                        )
                        RETURN NUMBER;

TYPE tab_CustomersType IS TABLE OF my_package.rec_CustomersType;

TYPE rec_CustomersType IS RECORD(
  customer_id  number(10),
  name    varchar2(255)
);

When calling it we see the error:

stmt.c:267:in oci8lib_300.so: ORA-06550: linje 12, kolonne 13: (OCIError)
PLS-00306: forkert antal eller typer af argumenter i kald til 'GET_CUSTOMERS'
ORA-06550: linje 12, kolonne 1:
PL/SQL: Statement ignored

Our Oracle version is:

 VERSION INFORMATION:
    TNS for Linux: Version 19.0.0.0.0 - Production
    Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
    TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
 Version 19.7.0.0.0

I ran a git bisect that point to bfd14d4 as the offending commit.

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