how to create parameterised form in oracle 10g?
and create another form from the value of the form?
AND how to assign value to a parameter?
sincerly your
mamun

Answers were Sorted based on User's Feedback



how to create parameterised form in oracle 10g? and create another form from the value of the form?..

Answer / sudipta santra

First U need to create one Param-List object inside the form
like as below:-

list_id := Create_Parameter_List('PAR_CONTRACT');
Add_Parameter(list_id,
'CONTRACT_NO',TEXT_PARAMETER,:TBL_CONTRACT.CONTRACT_NO);
call_Form('T:\Form2.fmx',no_hide,no_replace,
no_query_only,list_id);

in the Form2.fmb: You need to catch those parameter value in
either trigger Pre-Form or in trigger When-New-Form-Instance.

If you have any doubt then please drop me a mail about your
confusion on : sudipta_santra@infosys.com

Is This Answer Correct ?    0 Yes 0 No

how to create parameterised form in oracle 10g? and create another form from the value of the form?..

Answer / sudipta santra

In form-1 the written code is given below:-

list_id := Create_Parameter_List('PAR_CONTRACT');
Add_Parameter(list_id,
'CONTRACT_NO',TEXT_PARAMETER,:TBL_CONTRACT.CONTRACT_NO);
call_Form('T:\Form-2.fmx',no_hide,no_replace,
no_query_only,list_id);

In form-2 the written code is given below:-
Either in the trigger When-New-Form-Instance or in trigger
Pre-Form :-

SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,WINDOW_STATE,MAXIMIZE);
BEGIN
IF ( :PARAMETER.PAR_CONTRACT IS NOT NULL ) THEN
/* Use this value in the WHERE clause of MY_BLOCK */
Set_Block_Property('TBL_CONTRACT',DEFAULT_WHERE,
'PAR_CONTRACT = :PARAMETER.PAR_CONTRACT');
GO_BLOCK('TBL_CONTRACT');

Execute_Query;
END IF;
END;

In that way we can use parameter inside the several forms.

If you have still any doubts , then please reach me out at:
sudipta_santra@infosys.com

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Forms Reports Interview Questions

What are the ways to monitor the performance of the report?

1 Answers  


What are the default parameter that appear at run time in the parameter screen?

1 Answers  


based on parameter value layout of report should change

1 Answers  


How to create placeholder columns?

2 Answers  


What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

1 Answers  






what is the difference between call_form, new_form and open_form?

0 Answers  


in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

0 Answers  


What are the different file extensions that are created by oracle reports?

1 Answers  


what is the exact navigation to create a radio button in form6i? can i create the radio button in report6i?

2 Answers   Satyam,


what is the source file of po report?

1 Answers   Convergys,


There are Two pl/sql Libraries Lib1,Lib2 are attached to a form and these two libraries contains functions with same name fun1 (i,e lib1 have a function fun1 and lib2 also have a function fun1).how to call these functios from forms?

3 Answers   3i Infotech,


With which function of summary item is the compute at options required?

1 Answers  


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)