Trying to pass parameters and getting FRM-47009 errors
346658Jan 24 2007 — edited Jan 24 2007Hi All
Am I doing this right? I want to call the form CRS0001 and pass it these 2 parameters,
:control.c_cagecdxh
:control.c_refnumha.
I keep on getting error FRM-47009 on each add_parameter statement upon execution. Form CRS0001 does get called though.
Declare
pl_id paramlist;
pl_name varchar(15) := 'cage_ref_list';
pl_name_cage varchar2(5) := :control.c_cagecdxh;
pl_name_refn varchar2(32) := :control.c_refnumha;
.
.
begin
.
.
.
.
add_parameter(pl_id,pl_name_cage,text_parameter,:control.c_cagecdxh);
add_parameter(pl_id,pl_name_refn,text_parameter,:control.c_refnumha);
call_form('CRS0001',no_hide,no_replace,no_query_only,'cage_ref_list');
Thanks