Nov 252014
 

Built-in Subprogram is divided into two categories:

  • Restricted Built-in Subprograms
  • Unrestricted Built-in Subprograms

Restricted Built-In Subprograms:

Restricted built-in affects navigation in your form either external screen navigation or internal navigation. You can call these built-ins only from triggers where no internal navigation is occurring. Restricted built-ins cannot be called from the Pre and Post triggers which fire when Oracle Forms is navigating from object to another. Restricted built-ins can be called from the When triggers that are specific to interface items, such as When-Button-Pressed or When-Checkbox-Changed. Restricted built-ins can also be called from any of the When-New-“object”-Instance triggers and from key triggers.

Examples:

Clear_Block,

Go_Block,

Next_Block,

Previous_Block,

Clear_Form,

Commit_Form,

Enter,

Exit_Form,

Open_form etc.

Unrestricted Built-In Subprograms:

Unrestricted built-ins do not affect logical or physical navigation and can be called from any Trigger.

Examples:

Show_Alert

Pause

Set and Get Built-ins (Ex: Get_Item_Property, Set_Item_Property)

Find Built-ins (Ex: Find_Block, Find_View etc)

Call_Form etc.

System Variables in Oracle Forms

System variables are oracle form variables that are used to control the way an application behaves.

List of system Variables:

  • Form_Status
  • Block_Status
  • Record_Status
  • Coordination_Operation
  • Master_Block
  • Current_Block
  • Current_Form
  • Current_Item
  • Current_Value
  • Cursor_Block
  • Cursor_Record
  • Cursor_Item
  • Cursor_Value
  • Last_Form
  • Last_Record
  • Last_Query
  • Message_Level
  • Suppress_Working
  • Mode

Types of Form Builder Variables

Different types of Form builder variables are: 

  • Item (:block_name.item_name)
  • Global (:GLOBAL.variable_name)
  • System (:SYSTEM.variable_name)
  • Parameter (:PARAMETER.name).

 

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)