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

[HELP/HOW TO] Pass udt types into a function call in PLSQL #310

Closed gpgpublickey closed 1 year ago

gpgpublickey commented 1 year ago

Hi everyone, need some assist about how to call a function inside of a package which receives an udt type and returns an udt type? I'm having problems to define the returned type and execute it successfully

The examples I saw works for stored procedures, any hints or tips?

Thanks

alexkeh commented 1 year ago

Here's an ODP.NET UDT example using a function. https://www.codeproject.com/Articles/1139474/ODP-NET-User-Defined-Type-Implementation

It's based upon unmanaged ODP.NET, but the code isn't too different from managed/Core versions.