oracle11g - passing parameters between forms -
hi i'm trying passing parameters between forms have error: frm-92101 there failure in forms server during startup. wanna place button on employee form when pressed, call employee/dependent form , automatically query dependents employee being viewed on employee form. icreated employee form , add button.i assigned trigger when bouton pressed :
declare pl_id paramlist; begin pl_id := get_parameter_list('tmpdata'); if not id_null(pl_id) destroy_parameter_list( pl_id ); end if; pl_id := create_parameter_list('tmpdata'); add_parameter(pl_id, 'employeessn', text_parameter, :ssn); run_product(forms, 'empdepn', synchronous, runtime, filesystem, pl_id, null); end;
after add parameter employee/dependent created parameter called employeessn code bellow , add parameter employeessn , add when-new-form-instance trigger :
declare blk_id block; begin -- obtain block id of employee block. -- master block in empdepn master/detail form. blk_id := find_block('employee'); if not id_null(blk_id) -- check make sure our parameter has value. if form -- executed itself, parameter null. -- if form called employee parameter -- passed along , assigned to: parameter.employeessn if (:parameter.employeessn not null) -- since have parameter, use alter clause -- property becomes ssn=:parameter.employeessn set_block_property(blk_id,default_where,'ssn=' || : parameter.employeessn); -- navigate employee block , execute query automatically go_block('employee'); execute_query; end if; end if; end;
any idea please, help
Comments
Post a Comment