ruby-plsql icon indicating copy to clipboard operation
ruby-plsql copied to clipboard

0.8.0 breaks Oracle function

Open jacobat opened this issue 4 years ago • 0 comments

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 bfd14d41674a97c5035460817ad58ec6532311b3 as the offending commit.

jacobat avatar Oct 05 '21 07:10 jacobat