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 the O’Reilly learning platform.

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