How to check Parameter List value in Oracle PL/SQL? -

How to check Parameter List value in Oracle PL/SQL? -

i created param list , add together parameter, when want check if parameter , value has been added, cannot value added. what's wrong code :

if not id_null(get_parameter_list('rpt')) destroy_parameter_list('rpt'); end if; v_param_list := create_parameter_list('rpt'); add_parameter(v_param_list,'par_where',text_parameter,'where id = 1010'); begin get_parameter_attr(v_param_list,'par_where',v_param_type,v_temp); message('par_where:'||v_temp); exception when others message('couldn''t value : par_where'); end;

how retrieve parameters , values in param list ?

as griffeydog said, there no way retrieve parameter list items. had same problem , solved using database. way utilize workarounds. solution pass id in parameter list. id represents pl/sql collection. 1 time id retrieved easy collection keys or values. if need more details allow me know code years old.....

oracle parameters plsql oracleforms