Skip to main content
  1. Tags/

Oracle

2016

When you get bit by precision & scale in PL/SQL…
··250 words·2 mins
Programming Oracle
I got a bug assigned to me where my application was returning an incorrect value. Some background: The function was an age check function which takes in date of birth & start date and returns the age. In this specific case, the date of birth was 05.01.1951 and start date was 01.01.2016 - the expected age that was to be returned(after round off to 4) was 64.9892. The application, however was returning 65.

2012

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:
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