Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Triggers In Forms !!!! HELP !!!!!

Triggers In Forms !!!! HELP !!!!!

From: Nitin Tekchandani <EASYNITIN_at_NETSCAPE.NET>
Date: 15 Jan 2002 03:36:07 -0800
Message-ID: <e8140ffc.0201150336.33e0025a@posting.google.com>


Hi all,
Have written a procedure which fetches a set of values from a table...and displays these values in the corresponding fields in the form
am calling this procedure from WHEN-VALIDATE-ITEM trigger on a paricular item say First_Name .. Field First_Name has a LOV attatched to it....
My problem is i want to display the values returned from the above said procedure as soon as i select a value in First_Name (from LOV)

WHEN-VALIDATE-ITEM trigger is working fine but is fired only when i shift the focus from Field First_Name (on which it is being called) to any other field.

i want to know that from which item-level trigger should i call the procedure
such that the values in other fields are displayed as soon as i select First_name from its LOV Received on Tue Jan 15 2002 - 05:36:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US