You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
We tried to reproduce this issue with the following test case but it passes on all versions from v0.8.0 through current master (Oracle 23c Free and Oracle 11g XE):
Could you provide a minimal reproducible example (table DDL, type/package definition, and the Ruby call) that triggers the PLS-00306 error? There may be something specific to your schema setup that we are not capturing in our test.
Sorry, I haven't been working with Oracle for a while so I'm not able to provide more detailed information about this issue. Perhaps just close the issue?
Activity
Add failing test for TABLE OF RECORD OUT parameter (rsim#203)
yahonda commentedon Apr 13, 2026
We tried to reproduce this issue with the following test case but it passes on all versions from v0.8.0 through current master (Oracle 23c Free and Oracle 11g XE):
Could you provide a minimal reproducible example (table DDL, type/package definition, and the Ruby call) that triggers the
PLS-00306error? There may be something specific to your schema setup that we are not capturing in our test.yahonda commentedon Apr 13, 2026
See #263 for the test case we used.
jacobat commentedon Apr 13, 2026
Sorry, I haven't been working with Oracle for a while so I'm not able to provide more detailed information about this issue. Perhaps just close the issue?
yahonda commentedon Apr 13, 2026
Thanks for the update.
Yes. Let me close this issue.