Suivre ce blog
Editer l'article Administration Créer mon blog


Free tool

Look and Feel Project

21 août 2007 2 21 /08 /août /2007 10:41

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.

Partager cet article

Francois Degrelle - dans Oracle Forms
commenter cet article