ruby-plsql
ruby-plsql copied to clipboard
0.8.0 breaks Oracle function
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.