Oracle Form
Sample code for call form function with parameter.
Declare
Lp_param Paramlist;
Lp_param_xl Paramlist;
Begin
If Id_null(Lp_param_xl) Then
Lp_param_xl := CREATE_PARAMETER_LIST('xl');
ADD_PARAMETER('xl','P_1',text_parameter, p_1);
ADD_PARAMETER('xl','P_2',text_parameter, p_2);
Call_form('UW_FRM_MR_08_10G',no_hide,no_replace,no_query_only,'xl');
Destroy_parameter_list('xl');
End if;
Exception
WHEN FORM_TRIGGER_FAILURE THEN
Raise form_trigger_failure;
End;
0 comments:
Post a Comment