Oracle Forms

Loading CSV in Oracle Forms

February 21, 2008

Yesterday, I and my team mates conducted a brownbag session about a functionality that allows loading of CSV files to a database table. The general overview of this functionality is to call a Unix shell script that invokes SQL Loader to load the CSV to the table. The first stage is uploading the CSV file [...]

Read the full article →

Restrict User From Entering More Than 100 Records

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;

Read the full article →