Feb 5, 2008

Oracle - Call Form Function


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: