Oracle Forms (MOSC)

MOSC Banner

Generating display only output from a Form to Browser

edited Feb 17, 2017 10:28PM in Oracle Forms (MOSC) 1 commentAnswered ✓

Hello,

This is on Oracle forms 10g.  And this is NOT Oracle EBS.

Bullets shown below explains the scenario and the requirement.

1. We have a display only form that looks like  the image that is attached here.

2. I have a POST-QUERY trigger of the data block that does following.

begin

  select first_name, salary into :departments.empname, :departments.sal

     from hr.employees where employee_id = :departments.manager_id;

     -- highlight as per your criteria

     if :sal >= 10000 then

                  -- create highlight visual attribute with color of your choice to highlight

         display_item('departments.empname', 'highlight');

     else

                 -- create default1 visual attribute to restore to normal view

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center