Calling PL/SQL from the OAF page

In this recipe we are going to call some SQL from our page. We will add a button to the page and when a user clicks on the button, we will call a database package that will insert a record into a database table. We will perform the following tasks:

  • Adding a button to execute the SQL statement
  • Creating a method in the application module
  • Calling the method from the controller class

Adding a button to execute the SQL statement

We are now going to create a button. We are going to use the button to call a method that executes the piece of SQL code, which we will add afterwards.

How to do it...

To add a button, perform the following steps:

  1. In the Application Navigator tab, click on the CreateSocietyPG.xml page.
  2. In the Structure ...

Get Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.