Hero Image
My Path to node.js and Oracle Glory - Volume 3

Next step - node.js setup on Ubuntu. This was remarkably easy! I went to https://nodejs.org/ and viewed their Downloads section, where I then went to “Installing from package managers”. That link takes you to this URL on GitHub. If you read the first line of “Debian and Ubuntu based Linux distributions”, you’ll note you should go to nodesource’s blog post for the most up to date instructions. I did what I was told - read what they have to say on the page - helpful stuff!

March 16, 2015 Read
Hero Image
My Path to node.js and Oracle Glory - Volume 2

OK, so now having established my database server in Volume 1 of this series, I now need to move to the next step - setting up my chromebook with Linux in order to facilitate node.js development. I chose a chromebook as my dev machine of choice as I wanted something that natively runs on Linux, but didn’t want to pay as much as a Mac and didn’t really like the Linux based machine options out there… Google is doing a great job with these and after having my chromebook for a little over a week - I have to say I love it…

March 14, 2015 Read
Hero Image
My Path to node.js and Oracle Glory - Volume 1

I am starting a new personal project with the following goals in mind: Learn JavaScript (I’m a beginner, but been reading/implementing for a while) Learn node.js Create a RESTful API using node.js calling a remote database server using Oracle’s node driver (node-oracledb) API should be simple to understand API in the backend should use the HR sample schema When using node.js, goal is to form a service request object in javascript and pass that object to a stored procedure in Oracle as an IN parameter, the same stored procedure should return a response object that will be parsed in javascript and the results displayed DISCLAIMER - When I actually have free time to develop - I am primarily a PL/SQL developer – I love PL/SQL - there I said it!

March 9, 2015 Read
Hero Image
Name:Value Encryption Utility using PL/SQL

I recently ran into an issue where, as part of a webservice call I was making using the Oracle APEX_WEB_SERVICE API, I needed to pass the application id and password in the soap header, but I did not want those sensitive data elements to be exposed in my pl/sql code in cleartext. I decided I wanted to encrypt the data and retrieve it at run time as a function call. I tried to find a way to do this via Stack Overflow, Google, etc.

December 17, 2014 Read