Passing Back Table Information from Oracle .NET Stored Procedures

[G.Doten]

Are there no other uses of SqlPipe (OraclePipe) that might allow you to
get the data back that you need? I've not really used that class so
don't know it's full capabilities.

I just ran across this working on a database this morning:

using(SqlConnection connection = new SqlConnection("context
connection=true"))
{
connection.Open();
// Use the connection
}

Kind of interesting. A special connection string that can be used when
you are in a C# stored procedure and want to open a connection back to
the database the code is running in. Hadn't seen that one before.

Documented with SQL Server 2005, presumably Oracle has it as well.