Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product is unavailable at the time of the call, Oracle Forms returns a message to the operator.

To indirectly reference a parameter use the NAME IN, COPY 'built-ins to indirectly set and reference the parameters value' Example name_in ('capital parameter my param'), Copy ('SURESH','Parameter my_param')

When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to produts invoked with the run_product built-in subprogram.

View by structure and view by type .

View by structure.

By setting the Restrict To List property to true in the parameter property sheet.

By using the tables/columns button and then specifying the table and the column names.

While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.

No.

When confine mode is on, an object cannot be moved outside its parent in the layout.

By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.

1. Using static values.2. Writing select statement.

1.Source pane. 2. Interpreter pane

1.Source pane. 2. interpreter pane. 3. Navigator pane.

Rep file and Rdf file.

Previewer.

Yes

Lexical reference is place_holder for text that can be embedded in a sql statements. A lexical reference can be created using & before the column or parameter name.

Bind reference are used to replace the single value in sql, pl/sql statements a bind reference can be created using a (:) before a column or a parameter name.

It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.