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.
CURSOR COLUMNLIST IS
SELECT DISTINCT COLUMN_NAME, TABLE_NAME
WHERE TABLE_NAME IN 'TERRITORY_MASTER','PARTICIPANT_MASTER','PARTICIPA NT_TERRITORY') ORDER BY COLUMN_NAME;
cnt := 0;
FOR i IN COLUMNLIST LOOP
cnt := cnt + 1;
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?