Hello Oracle Community,
I am currently developing an application using ODP.NET on .NET 6, and I've encountered an issue when trying to call a stored procedure that takes a user-defined type (UDT) table as a parameter. The Oracle database version I am working with is 11g.
The specific error message I receive is as follows:
ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to 'GET_TYPE_SHAPE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
This error occurs when I attempt to invoke the stored procedure, which is designed to accept a UDT table parameter. I've ensured that the UDT is correctly defined and matches the expected structure in the database. However, the call to the stored procedure seems to be failing due to an issue related to the UDT parameter handling.
I am seeking advice or solutions from anyone who has faced a similar issue or has expertise in working with UDTs and stored procedures in ODP.NET, especially in the context of .NET 6 and Oracle 11g. Any insights into how to resolve the ORA-06550 and PLS-00306 errors would be greatly appreciated.
Thank you in advance for your assistance and suggestions.