How to call Oracle table function (pipelined function) from .NET

Question

from my .NET application I have to invoke an Oracle pipelined table function. Do I need to map the Oracle UDTs (object and table) and to add a parameter for the table object to the ADO.NET Command object, or should I use a Data Reader?

I know that I have to map the Oracle UDTs to .NET classes when I want to pass a table to Oracle procedure. Can I use the same method to invoke a pipelined function? Or should I specify in my ADO.NET Command the Text "SELECT * FROM TABLE(myFunction(...))" and use a Data Reader for every row?

Thanx in advance!

Andrey Belykh · Accepted Answer · 2016-12-09 21:15:23Z

0

The easiest will be to use SELECT * FROM ..., however the SQL that would work in all versions of Oracle maybe like this:

SELECT * FROM TABLE(CAST(myFunction(...) AS functionReturnType))

answered Dec 9, 2016 at 21:15

Andrey Belykh

2,6744 gold badges36 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to call Oracle table function (pipelined function) from .NET

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related