Programming

Fixing FRM-41336: Populate_List: invalid column type for column 2 error in Oracle Forms

I spent the past hour and a half trying to fix this stupid error.

Here’s the situation:

I have a Poplist(aka dropdown list/ list item).  The poplist is populated by a query defined in a Record Group. The query is on the lines of

select id, name from employees

The column types are correctly defined. And yet I kept running into

FRM-41336: Populate_List: invalid column type for column

error message. Looking at the description for the message:

FRM-41336: Populate_List: invalid column type for column.
Cause:The record group does not have a column of the same type.
Action:Make sure record group has a column of the same type.

Translation:

All the columns in your query must of the same data type. You can’t mix a numeric & varchar column when you’re going to populate the value into a List item. Why is this stupid restriction present, I have no freaking clue. Ended up casting the id to a varchar field:

select to_char(id), name from employees

And all is well. For now, till another silly limitation will screw my happiness.

1 Comment

  1. Pingback: Sathya

Leave a Reply

Your email address will not be published. Required fields are marked *