Forum Stats

  • 3,771,070 Users
  • 2,253,218 Discussions


How could I enter a runtime WHERE condition in a Oracle Forms12?

User_S7PVR Member Posts: 18 Green Ribbon
edited Oct 27, 2021 6:09PM in Forms

In Forms 6 runtime there was an option to enter a ':' in a text FIELD to bring up a prompt to enter a WHERE condition during runtime so users could enter anything they wanted. 

After we upgraded from 6i to 12, the option do not have any effect in Forms12. 

We would like know if something like that exists in Forms 12 runtime for dynamically entering a condition for WHERE clause. 

Any help would be appreciated. 



  • Aaron L.
    Aaron L. Member Posts: 27 Red Ribbon
    edited Oct 27, 2021 7:14PM

    Did you enter a query, put the ampersand (&) in the field, and then execute the query?

    I looked up that error and someone said that option is turned off by default.


    My 12c just says

    FORMS_RESTRICT_ENTER_QUERY in my default.env file

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,911 Employee

    In 12, FORMS_RESTRICT_ENTER_QUERY is enabled (TRUE) by default to enhance security. To disable this functionality and allow users to enter custom WHERE clauses, set FORMS_RESTRICT_ENTER_QUERY=FALSE

    Michael Ferrante

    Senior Principal Product Manager


    Twitter: @OracleFormsPM