Home » Developer & Programmer » Forms » FRM-40733 error (Oracle Developer Suite 10g, Windows XP SP3)
FRM-40733 error [message #520175] Fri, 19 August 2011 01:42 Go to next message
Roger22
Messages: 98
Registered: April 2009
Location: Brasov, ROMANIA
Member
Hello,
I've created the LOV at design time, and the RG at runtime.
The code in the when-button-pressed trigger of the LOV button is:

declare
	rg_id RecordGroup;
	rg_col GroupColumn;
	l_row number(12):= 1;
  l_coll abc_type.varchar2_tbl;
  lv_id LOV;
begin
  rg_id := find_group('RG_DYNAMIC');  -- RG_DYNAMIC is the Group Name
  if id_null(rg_id) then
    rg_id := create_group('RG_DYNAMIC',Form_scope, 100);
    rg_col := add_group_column(rg_id,'COD',char_column,40);
  end if;
  l_coll := get_capat_transa(getCapatTransa2);
  for i in l_coll.first .. l_coll.last loop
  	--:system.message_level := 0;
  	add_group_row(rg_id, END_OF_GROUP);
  	set_group_char_cell(rg_col,l_row,l_coll(i));
  	l_row := l_row+1;
  --	:system.message_level := 25;
  end loop;
  -- add the RG to the LOV
  lv_id:=find_lov('LOV_TRANSA');
  set_lov_property(lv_id,group_name,rg_id);
end;
 
go_item('<my_text_item>');
do_key('list_values');


First time i press the button, 3 values are returned, and it's ok, they come from that collection. Second time i press the button i got the error FRM-40733: PL/SQl built-in SET_GROUP_CHAR_CELL failed (2 times), then the LOV appears. But i don't want to appear that error. What i'm doing wrong?

Please help.
Re: FRM-40733 error [message #520187 is a reply to message #520175] Fri, 19 August 2011 03:22 Go to previous message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
You're not clearing the record group before you re-populate it.
Previous Topic: comparing date in form 6i
Next Topic: 10g - enter_query/execute_query-problem
Goto Forum:
  


Current Time: Wed Aug 21 14:29:56 CDT 2024