- 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