Hi,

In Oracle forms, I have a Tlist which will containt all distinct column names from three different tables.

While selecting I select both the column and the table name. When I add it to the list, I want the column name to be the label and the value should be 'table name.column name'. Below is the script I wrote.

DECLARE

cnt number;

CURSOR COLUMNLIST IS
SELECT DISTINCT COLUMN_NAME, TABLE_NAME
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME IN 'TERRITORY_MASTER','PARTICIPANT_MASTER','PARTICIPA NT_TERRITORY') ORDER BY COLUMN_NAME;

BEGIN

clear_list(''REPORT.COLUMN_LISTED');

cnt := 0;
FOR i IN COLUMNLIST LOOP
cnt := cnt + 1;
add_list_element('REPORT.COLUMN_LISTED',cnt,i.COLU MN_NAME,i.TABLE_NAME||'.'||i.COLUMN_NAME);
END LOOP;

end;

When I run the form I get the below error:

FRM-41330 : Could not insert list element into Column_listed.

I even tried storing the concatenated value in a variable and then passing the variable as the value for the list. It gives the same error.

When it accepts concatenated strings as Lable, why not as value?