Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

0.8.0 breaks Oracle function #203

Open
jacobat opened this issue Oct 5, 2021 · 0 comments
Open

0.8.0 breaks Oracle function #203

jacobat opened this issue Oct 5, 2021 · 0 comments

Comments

@jacobat
Copy link

jacobat commented Oct 5, 2021

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant