Everybody is already convinced about the strength and benefits of AJAX. There is only one thing that keeps bothering me when I’m using AJAX within Apex. For every AJAX call, you have to define a new application process.
b) Create an application item with the name AJAX_PROCEDURE
Instead of writing your PL/SQL code for the AJAX call in the application process, you have to write it on the database as a procedure (or a package procedure) Ex: pck$ajax_examples.prc$first_example
Step 2: Javascipt
The ajaxResult variable will contain the result of your AJAX call!
This method is only recommended in an inTRAnet environment because your database is open to SQL Injections. You can also build in extra security, for example by checking your AJAX call againt a database table to make sure the call is permitted.
In a next blog I will explain how you also can generalise the passing of params to the Ajax call.