Object UDT => GET_Type_SHAPE issue

oracle / dotnet-db-samples

.NET code samples for Oracle database developers #OracleDotNet

http://otn.oracle.com/dotnet

MIT License

413 stars 191 forks source link

Object UDT => GET_Type_SHAPE issue #308

Closed mezJihad closed 1 year ago

mezJihad commented 1 year ago

I folow the sample provided for using object UDT, but i have this exception after executing the sample :

ORA-06550: Ligne 1, colonne 13 : PLS-00306: numéro ou types d'arguments erronés dans appel à 'GET_TYPE_SHAPE' ORA-06550: Ligne 1, colonne 7 : PL/SQL: Statement ignored

I'm using .Net 6 and Oracle.ManagedDataAccess.Core 3.21.110

alexkeh commented 1 year ago

UDTs are supported with ODP.NET Core starting with version 23. Use the following download (or later versions when they become available). https://www.nuget.org/packages/Oracle.ManagedDataAccess.Core/23.2.0-dev

mezJihad commented 1 year ago

Hello, thank you for you're response.

I tried the new release V23.2.0-dev, but i have same issue.

There is please another alternatif of using UDT : I want to send list of items to my stored procedure.

alexkeh commented 1 year ago

You can use PL/SQL associative arrays in ODP.NET if it's a list of items of the same type.