| Issue with List Item [message #620315] |
Thu, 31 July 2014 02:50  |
 |
RaShi.Raj
Messages: 84
Registered: May 2014
Location: Bangalore
|
Member |
|
|
Hi All,
I have 2 questions here...
1. Is it mandatory to have poplist column datatype as Char ? I was selecting a number datatype column in a query of a record group and while populating it to list item ( which is also of number type) I was getting an error - "FRM-41335 : Populate_List : invalid column type for column 1". When I changed the query to select to_char(column1)..., I could get rid of this error. This seems to be working fine with 6i i.e. selecting number type.
2. I need to populate a list item (using record group and populate_list) with around 100 thousand records. While populating this I'm getting an error "FRM 93652: The runtime process has terminated abnormally". Is this not feasible to do this way? Is there any alternative to achieve this result?. I don't see this error if I put a filter condition so that it populates less records.
Thanks,
Rashi
|
|
|
|
| Re: Issue with List Item [message #620316 is a reply to message #620315] |
Thu, 31 July 2014 02:53  |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
1) It should work with number as far as I'm aware
2) 100,000 rows in a list item sounds unworkable, it's probably running out of memory, use an LOV instead.
|
|
|
|
| Re: Issue with List Item [message #620317 is a reply to message #620316] |
Thu, 31 July 2014 02:54 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
|
Personally I'd never use a list item for anything more than about 20 values, and I'd certainly never go past a 100. LOV's are a lot more user friendly for a lot of values.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
