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

Popular posts from this blog

windows - Single EXE to Install Python Standalone Executable for Easy Distribution -

c# - Access objects in UserControl from MainWindow in WPF -

javascript - How to name a jQuery function to make a browser's back button work? -