Skip to Main Content
Pro ODP .NET for Oracle Database 11g
book

Pro ODP .NET for Oracle Database 11g

by Edmund Zehoo
April 2010
Intermediate to advanced content levelIntermediate to advanced
468 pages
10h 31m
English
Apress
Content preview from Pro ODP .NET for Oracle Database 11g

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

ASP.NET 3.5 Unleashed

ASP.NET 3.5 Unleashed

Stephen Walther
Microsoft® .NET Compact Framework (Core Reference)

Microsoft® .NET Compact Framework (Core Reference)

Andy Wigley, Stephen Wheelwright, Robert Burbidge, Rory MacLoed, Mark Sutton
Professional C# 5.0 and .NET 4.5.1

Professional C# 5.0 and .NET 4.5.1

Christian Nagel, Jay Glynn, Morgan Skinner

Publisher Resources

ISBN: 9781430228202Purchase book