FRM-40733 error [message #520175] |
Fri, 19 August 2011 01:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|