Home | Articles | Oracle Forms | Built In Routines

Built In Routines

CALL_FORM built-in - Oracle Forms

Runs an indicated form while keeping the parent form active. Form Builder runs the called form with the same Runform preferences as the parent form. When the called form is exited Form Builder processing resumes in the calling form at the point from which you initiated the call to CALL_FORM. ... Full story

POST built-in Oracle Forms

Writes data in the form to the database, but does not perform a database commit. Form Builder first validates the form. If there are changes to post to the database, for each block in the form Form Builder writes deletes, inserts, and updates to the database.Any data that you post to the database is committed to the database by the next COMMIT_FORM that executes during the current Runform session. Alternatively, this data can be rolled back by the next CLEAR_FORM. ... Full story

DISPLAY_ITEM built-in Oracle Forms

Maintained for backward compatibility only. For new applications, you should use the SET_ITEM_INSTANCE_PROPERTY built-in. DISPLAY_ITEM modifies an item’s appearance by assigning a specified display attribute to the item. DISPLAY_ITEM has the side-effect of also changing the appearance of any items that mirror the changed instance. SET_ITEM_INSTANCE_PROPERTY does not change mirror items. ... Full story

DOWN built-in

Navigates to the instance of the current item in the record with the next higher sequence number. If necessary, Form Builder fetches a record. If Form Builder has to create a record, DOWN navigates to the first navigable item in the record. ... Full story


Execute_Query clears the current block, opens a query, and fetches a number of selected records ( items that are with base_table TRUE). If there are changes to commit, Form Builder prompts the operator to commit them before continuing EXECUTE_QUERY processing. This alert prompt can be avoided by using NO_VALIDATE parameter with EXECUTE_QUERY ... Full story

total: 5 | displaying: 1 - 5

Log in

Featured author

Amal Singh

Freelancer oracle Consultant and Oracle Trainer for Corporates.Conducted various oracle workshops in educational institutes and delivered seminars on oracle.