Timothy E. Archer

At the University for which I work, we had a need to integrate our Sungard HE Banner ERP system with Barnes and Noble (our outsourced bookstore) to process book vouchers, and with our credit card processing API (Intellipay). Both of these applications required us to post charges and payments directly to the student’s account.

With our Barnes and Noble integration, the process works as such: continue reading…

Have you ever needed to generate a random number within your Oracle PL/SQL code? I recently had a need to just this. My requirement was to generate a random 6 digit pin number for users to login to our web systems with.

I found that the dbms_random package does exactly what I need, and is extremely simple to use.

My first test of this was just to run the statement: continue reading…