Suivre ce blog
Administration Créer mon blog

Search

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.

Forms EXEC_SQL

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

commentaires