oracle
When you get bit by precision & scale in PL/SQL…
· ☕ 2 min read · ✍️ Sathyajith Bhat
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.

The keys to Oracle…
· ☕ 2 min read · ✍️ Sathyajith Bhat
<td style="padding-top: 6px;" width="100%"> <strong><br /> sathyabhat<br /> <a href="https://sathyabhat.newsblur.com/story/the-keys-to-oracle/d37bc7">shared this story</a><br /> from <img style="vertical-align: middle; width: 16px; height: 16px;" src="https://icons.newsblur.com/8079.png" alt="" /> The Tom Kyte Blog:</strong> </td> "What do I have to do to become expert, where is the list of key things I need to do with regards to Oracle" This is a question I get on asktom frequently – what are the things I need to know, what do I have to do to become expert, where is the list of key things I need to do with regards to Oracle.

Fixing FRM-41336: Populate_List: invalid column type for column 2 error in Oracle Forms
· ☕ 1 min read · ✍️ Sathyajith Bhat
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.

Troubleshooting Oracle’s ORA-01017 errors
· ☕ 2 min read · ✍️ Sathyajith Bhat
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