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:
Calling a stored PL/SQL procedure as a standalone operation, for example, from validation code.
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 ...