oracle / dotnet-db-samples

.NET code samples for Oracle database developers #OracleDotNet
http://otn.oracle.com/dotnet
MIT License
408 stars 190 forks source link

[HELP/HOW TO] How to return PIPELINED tables in a function #312

Closed gpgpublickey closed 9 months ago

gpgpublickey commented 9 months ago

Hi guys, I need some help with this:

We have this kind of function inside of a package:

FUNCTION foo(p1_arg_type IN VARCHAR2,
                       p1_arg      IN VARCHAR2,
                       p2_arg_type IN VARCHAR2,
                       p2_arg      IN VARCHAR2) RETURN foo_tbl PIPELINED;

Is this supported by ODP.NET? Any example about how I need to call this function using PLSQL to pull the results? No idea how to return a pipelined table

Thanks

alexkeh commented 9 months ago

Here's a blog post on how to pipelined results in ODP.NET.