In form-1 the written code is given below:- list_id := Create_Parameter

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

Question Posted / sudipta santra

2 Answers
4964 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

Why oracle forms required?

1093

did u received a single file or multiple files

2055

Explain master-detail relationship with some examples.

1050

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

1746

How can we expand Parameter Form Canvas on Reports 6i?

2468

What is the difference between bind and lexical parameter?

1112

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2364

can you convert or reverse engineer a fmx back to a fmb file?

1221

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1499

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2058

all steps of bitmap report?

2394

What is the difference between flex mode and confined mode?

1101

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.