Forms and Dynamic SQL (EXEC_SQL)

I frequently see questions on Forums about how to handle a cursor  with a dynamic Where clause.

Oracle Forms has a special package named : EXEC_SQL that allows using dynamic SQL in the Forms application.

Here is a sample dialog that queries the EMP table with the Where clause given at runtime.

The first part of the query is hard coded in the Forms module, but you can enter any possible Where clause.

The corresponding code is located in the Dynamic_Cursor() program unit.

Get the Forms sample dialog here

Of course, this is just a single example of what you can do with the EXEC_SQL package.