Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook

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