Fixing FRM-41336: Populate_List: invalid column type for column 2 error in Oracle Forms โ€“ sathyasays.com
This page looks best with JavaScript enabled

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

 ·   ·  โ˜• 1 min read  ·  โœ๏ธ Sathyajith Bhat · ๐Ÿ‘€... views

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.

Share on

Sathyajith Bhat
WRITTEN BY
Sathyajith Bhat
Author, AWS Container Hero and DevOps Specialist

What's on this Page