How Can I Interface ADF BC with PL/SQL?

As the final topic in this chapter, we will look at a key requirement: how do you call PL/SQL from ADF BC? We’ll break this question down into three different usages of PL/SQL:

image Calling a stored PL/SQL procedure as a standalone operation, for example, from validation code.

image Returning data from PL/SQL to ADF BC as a variation on the preceding technique. You can use this technique for PL/SQL functions that return a value or for PL/SQL functions or procedures that contain OUT (or IN OUT) parameters.

Basing an ...

Get Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.