Programming
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.
2015
Download your Spotify My Music songs as MP3
··208 words·1 min
Programming
Spotify
I wanted a way to download my Spotify songs for offline listening. Ideally I’d subscribe to Spotify to make use of Offline feature, but they haven’t officially launched here so that’s out of the question.
A while back, I’d used spotify_to_mp3 which made use of Grooveshark to download, but Grooveshark shut down, leaving the script defunct. This gave me an idea to build something similar.
With this as the motivation, I built Spotify-dl to scratch an itch as well as to improve my Python skills.
2014
An Indian developer’s way of handling merge conflict
··92 words·1 min
Programming
Rants
Git
So this happened just now with a colleague. He’s been working for few months now.
My way of handling merge conflict:
Open WinMerge to diff See the conflicting part Correct the conflicting part by copying the changes to the destination file in WinMerge His way
Open WinMerge to diff See the conflicting part Opens the source file in Windows notepad Copies the entire contents to clipboard Opens a new tab in Notepad++ Pastes the contents Goes to the line to be corrected.
2013
Salute to Fabrice Bellard
··246 words·2 mins
Programming
I probably top the ranks of lazy arses who procrastinate like there’s no tomorrow - and then there’s Fabrice Bellard
Amongst others, he’s created/led
A 4G LTE base station running entirely in software on a standard PC. A new ASN1 compiler generating small and efficient C code. A PC emulator in Javascript: how much time takes your browser to boot Linux ? 2700 billion decimal digits of Pi computed with a desktop computer.
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
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.