Question: how to import data from excel file to oracle database by using oracle forms?
Answer: Create a button on the form with the name "IMPORT_EXCEL" and write a pl/sql on "WHEN BUTTON PRESSED" trigger. BEGIN. IF :System.Cursor_Block<>'GL_DAILY_COMPOUND_HEADER' THEN. ...  Now write the procedure "IMPORT_EXCEL_PROC" into the program unit. Don't forget to create required table and folder for procedure IMPORT_EXCEL_PROC.