how to pass 2 variables from one form to other form

Answers were Sorted based on User's Feedback



how to pass 2 variables from one form to other form..

Answer / farrukh shaikh

Assalam-o-Alikum.
you can pass the value of two variable from form F1 to form
F2
First you have to create the two parameter on form F2 name
p1 and p2 and save the form.
then you go on to F1 and write tis code on button on text
item through which you want to send the parameter.
Declare
para ParamList;
Begin
para:=get_parameter_list('plist') /*plist can be replace by
any character*/
if not id_null(para) then
destroy_parameter_list('plist');
end if;
para:=create parameter_list('plist');
Add_Parameter(para,'P1',variable_1);
Add_Parameter(para,'P2',variable_2);
---after this you can add
call_form('F2');
--you can see the argument pass through form F1 to FORM F2.
end;

Is This Answer Correct ?    10 Yes 7 No

how to pass 2 variables from one form to other form..

Answer / kris

Parameter list should be passed as argument in call_form
built in.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Forms Reports Interview Questions

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

0 Answers  


What are the built-ins used for processing rows?

1 Answers  


what u write in Ctl file

2 Answers  


how to pass 2 parameters from one form to other in oracle applications?

1 Answers  


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

0 Answers  






What is a Non Query Record Group?

1 Answers  


To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

2 Answers  


What are the difference between lov & list item?

1 Answers   ESS,


What are visual attributes?

1 Answers  


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

0 Answers  


What are the Built-ins to display the user-named editor?

1 Answers  


What is the use of Data Link in Reports?

3 Answers   BN, Convergys,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)