Skip to Main Content

Oracle Forms


For appeals, questions and feedback, please email

LOV in Forms

Sabina WagmanFeb 2 2024 — edited Feb 2 2024

It's been a while since I worked with LOVs last time :) I'm working in Forms and I have a very simple query in a record group. It works fine then I dont type a value in the field. Validate from list is set to Yes, but I don't want the list to appear when I type a correct value. I have tried to set it to No and do this in validate item trigger: V_LOV := SHOW_LOV('PORTAL'). But in that case I can click cancel in LOV and pass the field with an incorrect value. Not so good. Do anyone have any suggestions how to solve it?

Brgds Sabina

Post Details
Added on Feb 2 2024