| Regarding Call_form using parameter list [message #85407] |
Wed, 23 June 2004 01:45  |
K.Sateeshkumar
Messages: 16
Registered: March 2004
|
Junior Member |
|
|
Hi Experts,
My requirement is how to call a form using call_form built in procedure with parameter.This parameter value is a input to the called form.Based on this input value a excute_query to be executed in the called form.pl kindly help me.
Thanking You,
Regards
K.Sateeshkumar
|
|
|
|
| Re: Regarding Call_form using parameter list [message #85409 is a reply to message #85407] |
Wed, 23 June 2004 02:53  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Modify following code as per your requirment.
HTH
Himanshu
Declare
L_pl_id Paramlist;
L_pl_name VARCHAR2(10) := 'tempdata';
Begin
L_pl_id := Get_Parameter_List(L_pl_name);
If Id_Null(L_pl_id) THEN
Null;
Else
Destroy_Parameter_List(L_pl_id);
End If;
L_pl_id := Create_Parameter_List(L_pl_name);
Add_Parameter(L_pl_id,'P_SSN',TEXT_PARAMETER,'Y');
Call_Form('ALSU6080', HIDE, DO_REPLACE, NO_QUERY_ONLY,L_pl_id);
Check_Failure;
Exception
When Others Then
Message('Error....');
Raise Form_trigger_failure;
End;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
