Restrict User From Entering More Than 100 Records

by Mark Marucot on August 14, 2007

You can write following code at WHEN-CREATE-RECORD trigger of that block to restrict user entering upto 100 records.

IF to_number(:system.cursor_record) > 99 THEN
raise form_trigger_failure;
END IF;