oracle forms - call_form with paramlist
Date: Wed, 15 Jan 2003 16:06:01 +0100
Message-ID: <3e2570cf_at_post.usenet.com>
- Post for FREE via your newsreader at post.usenet.com ****
Hi,
I have problem with Oracle Forms when calling call_form with parameter list. It seems like the command call_form with parameter list parameter is not executed at all - while the same command without parameter list works OK.
Here's my code:
...
declare
pl_id paramList;
pl_name varchar2(20) := 'PL_NAME';
begin
pl_id := get_parameter_list(pl_name);
if Id_Null(pl_id) then
pl_id := create_parameter_list(pl_name);
if Id_Null(pl_id) then
message('Error while creating parameter list '||pl_name); raise form_trigger_failure;
end if;
add_parameter(pl_id, 'PARAM1', text_parameter, 'param1_value'); message('parameter list '||pl_name||' created ...'); else
message('Parameter list '||pl_name||' already exists!'); raise form_trigger_failure;
end if;
call_form('form_B',no_hide,no_replace,query_only);
- that works OK
call_form('form_B',no_hide,no_replace,query_only,pl_id); call_form('form_B',no_hide,no_replace,query_only,pl_name);
- !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- !!! neither of the two lines above doesn't work
- there's no warning or error message
- it seems like the lines are skipped
- the form 'form_B' is OK i guess
- ??? what's the problem ??????????????????????????????
destroy_parameter_list(pl_id);
end;
I'm developing on
Forms [32 bite] Release 6.0.8.8.0 (Production)
Oracle7 Server Release 7.2.2.3.0 - Production Release
PL/SQL Release 2.2.2.3.0 - Production Oracle Toolkit Release 6.0.5.34.1 (Production) PL/SQL Release 8.0.6.0.0 (Production)
Thanks in advance
PeetJ
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
- Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=