Home » Developer & Programmer » Forms » FRM-30351: No list elements defined for list item. (Xp,Forms11g)
FRM-30351: No list elements defined for list item. [message #529257] Sun, 30 October 2011 09:32 Go to next message
samssams2006
Messages: 28
Registered: July 2010
Junior Member
DECLARE
CURSOR GRP IS 
 SELECT RowNum rn, Letter_Group_ID||'-'||A_Desc    AName,Letter_Group_ID
 FROM  Hrs_Group;
 
BEGIN
Clear_list('Letter_Group_ID');

FOR I IN GRP LOOP
Add_List_Element('Letter_Group_ID',I.rn,I.AName,I.Letter_Group_ID);
end loop;
 
END;
 



FRM-30351: No list elements defined for list item.
List LETTER_GROUP_ID




Any Body have any suggestion.

Regards,
Sams
Re: FRM-30351: No list elements defined for list item. [message #529281 is a reply to message #529257] Sun, 30 October 2011 13:32 Go to previous messageGo to next message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
I would assume the cursor is returning 0 rows.
Put a message in the for loop to see.
Re: FRM-30351: No list elements defined for list item. [message #529305 is a reply to message #529281] Mon, 31 October 2011 01:00 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Quote:

FRM-30351: No list elements defined for list item.



Go to List Item Property and Set Elements in List with dummy value.
-> List Element as Dummy and its value 0.

Also read this post.
https://forums.oracle.com/forums/thread.jspa?threadID=293405


Hope it'll help you.

Regards,
Irfan

Re: FRM-30351: No list elements defined for list item. [message #529313 is a reply to message #529305] Mon, 31 October 2011 02:19 Go to previous messageGo to next message
samssams2006
Messages: 28
Registered: July 2010
Junior Member
Thankx cookiemonster for reply.
Sorry I did not mentioned in my post - List showing correct Values but gives compilation error only.
FRM-30351: No list elements defined for list item.
List LETTER_GROUP_ID

Quote:

Go to List Item Property and Set Elements in List with dummy value.
-> List Element as Dummy and its value 0.


After setting this property my problem solved.
thankx ranamirfan.

Regards,
Sams
Re: FRM-30351: No list elements defined for list item. [message #529322 is a reply to message #529313] Mon, 31 October 2011 03:07 Go to previous message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Thanks for the feedback.

Regards,
Irfan
Previous Topic: sql*plus configurations (date format) are not working in oracle form
Next Topic: Item Validation.
Goto Forum:
  


Current Time: Sat Sep 07 13:02:19 CDT 2024