Home » Developer & Programmer » Forms » dynamic list errors
dynamic list errors [message #383979] Sun, 01 February 2009 06:09 Go to next message
imuharram
Messages: 48
Registered: January 2009
Member
i have a list item, which is a database item and want to fill it with the values i have in the database to enable the user to choose one of the list elements as input.

this is the code that i have in When_new_form_instance

DECLARE
R_ID RECORDGROUP;
N NUMBER;
BEGIN
R_ID:= CREATE_GROUP_FROM_QUERY('Q_1','SELECT WO_TYPE_DESC, TO_CHAR(WO_TYPE_NO) FROM WO_TYPE');
N:=POPULATE_GROUP('Q_1');
POPULATE_LIST('WO_TRANS.WO_TYPE_NO','Q_1');
END;

wo_type_desc --> varchar2
wo_type_no --> number
wo_type --> table name
wo_trans --> datablock name

in the list item properties --> elements in list 0 , 0

i keep getting these errors FRM-32082 and FRM-30085 and i don't know why

i appreciate your quick response
Re: dynamic list errors [message #384004 is a reply to message #383979] Sun, 01 February 2009 12:39 Go to previous message
Littlefoot
Messages: 20893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is the root cause:
Oracle
FRM-32082: Invalid value for given item type.

Cause: You tried to specify a value for the initial value property or other values property that exceeds the value of the maximum length property.

Action: Specify a value that does not exceed the value of the maximum length property.
Check lengths and adjust them in order to get rid of the error. Once you do that, the following
Oracle
FRM-30085: Unable to adjust form for output.

Cause: Caused by an internal error, or memory allocation error.

Action: Contact your DBA or an Oracle support representative.
error will be resolved by itself (i.e. you don't have to worry about it).
Previous Topic: formula to get the total of salary
Next Topic: Lov Problem
Goto Forum:
  


Current Time: Mon Dec 05 04:39:05 CST 2016

Total time taken to generate the page: 0.11307 seconds