Skip to main content
  1. Posts/

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

··178 words·1 min·
Programming Oracle

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.

Sathyajith Bhat
Author
Sathyajith Bhat
Author, AWS Container Hero and DevOps Specialist.

Related

Troubleshooting Oracle’s ORA-01017 errors
··221 words·2 mins
Programming Oracle
Was writing this for Stack Overflow‘s tag wiki on ORA-01017, thought I’ll post it here as well. ORA-01017 is the error code shown my Oracle when a login attempt to the database was not successful. The full text of the error code is: ORA-01017: invalid username/password; logon denied Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was
10 minute bug fixes & web conference bloopers
··528 words·3 mins
Programming Humor
Came across this article via HN and I’m pretty sure most who work for Enterprise companies would’ve come across this at least once. Incredibly detailed post. Boss: Hey Ed, Sue in Detroit says that sometimes, the wrong Invoice Part Number is showing up on the Product History Screen. Can you help us figure this out. Ed: I’m busy with something else at the moment. Put the ticket in my queue.
Wakoopa officially shutdown – grab your data now
··232 words·2 mins
General Linux
About 2 weeks ago, Wakoopa announced that they will be shutting down their social network soon & focusing on “Corporate Research”. Unfortunately that day is here. Just received an email stating that as of today, you can grab an export of your data. This is what they have to say about the export The export is a CSV file containing the following columns: application name, subcategory, category, the number of seconds you've used the application in the hour, the hour you've used the application in, the date of the usage, the operating system and your user id.