Issue with List Item [message #620315] |
Thu, 31 July 2014 02:50 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/04ce8689c5dd4a0f56f99d5c1356c103?s=64&d=mm&r=g) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 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.
|
|
|
|