Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

open_form with parameter list and execute_query

495123Jun 16 2006 — edited Jul 11 2006
Hello all.
In a 6i form WBPressed trigger creates the parameter list
begin
    v_paramlist_id := create_parameter_list('FRM_PARM_LIST');
    add_parameter('FRM_PARM_LIST', 'P_CUST_NUM', TEXT_PARAMETER,
	              to_char(:CUSTOMER_INFO.CUST_NUM));
    
    open_form('CUSTOM_SCORING', ACTIVATE, SESSION,                    
                     NO_SHARE_LIBRARY_DATA, 'FRM_PARM_LIST');
  
   destroy_parameter_list('FRM_PARM_LIST');
end;
Then in the second form, WNFInstance trigger has:
    if :PARAMETER.P_CUST_NUM is not null 
	then
	GET_PARAMETER_ATTR('FRM_PARM_LIST', 'P_CUST_NUM', x, v_cust_num);
	set_block_property('CUST_SCORING', DEFAULT_WHERE,
				 'CUST_NUM = to_number('||v_cust_num||')');
	go_item('cust_scoring.cust_num');
	do_key('execute_query');
I get FRM-40505 Unable to perform query. It was working, but I broke it along the way. Does this much seem correct to open the second form and query the specific customer?

Upon opening the second form in the Developer tool, it cannot locate a custom Object Library called PARAMETERS. I deleted it & drug it in again from the original (sub-classed). Sould I do the entire library?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2006
Added on Jun 16 2006
7 comments
1,204 views