trouble with get_parameter_attr when passing parameters to new form
Date: Tue, 20 Oct 1998 15:00:19 -0700
Message-ID: <70j9tf$87j_at_hacgate2.hac.com>
[Quoted] Hello to all,
[Quoted] I seem to have a bit of trouble trying to use the function
get_parameter_attr.
When I create the parameter list in Form1 and I run into problem in Form2.
Hopefully, one of you can spot this problem and let me know where I did
wrong. Thanks for any suggestions.
In the first trigger (of Form1), I want to create a parameter list and here
is
what I used:
DECLARE
pl_name varchar2(20) := 'THEPARAMS';
pl_id PARAMLIST;
BEGIN
pl_id := Get_Parameter_List(pl_name);
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List(pl_id);
END IF;
pl_id := Create_Parameter_List(pl_name);
Add_Parameter(pl_id, 'FILENAME',TEXT_PARAMETER,:operation.filename);
Open_Form('Form2',activate,session,pl_id);
END;
In Form2, When-New-Form-Instance trigger:
DECLARE
paramtype number;
pl_id PARAMLIST;
pl_name varchar2(20) := 'THEPARAMS';
BEGIN
pl_id := Get_Parameter_List(pl_name);
if id_null(pl_id) then
:block.parameter := 'None!!!';
else
Get_Parameter_Attr(pl_id,'FILENAME',paramtype,:block.parameter);
end if;
END;
When I run Form2 by itself, the block.parameter is set to "None!!!" as
expected.
When I call Form2 from Form1, then I get the following error:
"FRM-47023. No such parameter named FILENAME exists in form FORM2."
I tested with the Get_Parameter_Attr in the first trigger (of Form1), it worked.
-Robert
Robert Hoy hoy_at_solaria.hac.com ----------------------------------------------------------------------------
"You are erratic, conflicted, disorganized...You lack harmony, cohesion,
greatness. It will be your undoing." said the arrogant Borg Seven of Nine on Star Trek Voyager. Received on Wed Oct 21 1998 - 00:00:19 CEST