| dynamic list errors [message #383979] |
Sun, 01 February 2009 06:09  |
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  |
 |
Littlefoot
Messages: 21823
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).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
