Skip to Main Content

IR

LinkDeptnoAscendingEmpnoEnameJobMgrHiredateSalComm
Single Row View207566JONESMANAGER78391981-04-022975-
Single Row View207788SCOTTANALYST75661982-12-093000-
Single Row View207876ADAMSCLERK77881983-01-121100-
Single Row View207902FORDANALYST75661981-12-033000-
Single Row View307499ALLENSALESMAN76981981-02-201600300
  • 1 - 5 of 10

Info

Method to use the query of an Interactive Report, including all user defined filters, sort orders, etc., in a pl/sql procedure.
Change the settings of the IR and then click the Run Procedure button to see the results of the pl/sql procedure.

Note: make sure the columns you use in your code are always present in the query result. In this example, columns EMPNO and JOB are used in the code and therefore these columns are set "not hide-able" for the user.

Results

Code

Page

Name
Page ID
Name

Region

Identification
Sequence
Title
Type
Source
Source Type
Region Source

Button

Name
Button Name
Text Label / Alt
Displayed
Sequence
Display in Region
Action When Button Clicked
Action
Execute Validations

Process

Name
Button Name
Type
Process Point
Sequence
Process Point
Run Process
Source
Process
Conditions
When Button Pressed