O'Reilly logo

Pro ODP .NET for Oracle Database 11g by Edmund Zehoo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Using PL/SQL and .NET CLR Stored Procedures with ODP.NET

Stored procedures remain one of the most common ways of separating the data tier from the logic tier of an application. They shield the developer from having to make changes to the code when the underlying database structure changes. And with stored procedures backed up by a powerful SQL dialect (PL/SQL), it isn't hard to see why many developers choose to stuff as much database logic as they can behind them.

In this chapter, we explore the different ways you can interact with PL/SQL code through ODP.NET. We will particularly look at how to accomplish the following:

  • Executing PL/SQL stored functions, functions, and anonymous blocks

  • Passing input data and retrieve output data from ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required