Michael McLaughlin
Rexburg, ID

Hear the Author!
Press to play


Fri, 18 Apr 2014 22:28:16 +0000
One thing that gets tedious in the IT community and Oracle community is the penchant for Windows only solutions. While Microsoft does an excellent job in certain domains, I remain a loyal Apple customer. By the way, you can install Oracle Client software on Mac OS X and run SQL Developer against any Oracle Database […]

Best UTL_FILE Practice
Wed, 16 Apr 2014 09:07:35 +0000
In a post a couple days ago, I promised to provide a best practice approach to reading external files with the UTL_FILE package. My first assumption is that you’re reading unstructured data because structured data is best read by external tables because external tables can read data much faster with the PARALLEL option. My second […]

Using UTL_FILE Package
Mon, 14 Apr 2014 05:46:53 +0000
Sometimes I’m surprised. Today, the surprise came when somebody pointed to a potential error in another author’s book. The person who asked the question had to send me a screen shot before I believed it. The author’s code encounters the following error because the code was designed to loop through a multiple line file, and […]

DBMS_JAVA Privilege Error?
Sat, 29 Mar 2014 19:59:59 +0000
It’s possible to get an error after granting privileges to an external file system. One of those errors is tedious to resolve until you understand the rules governing Java NIO file permissions. You grant privileges to external file systems as the sys user with the grant_permission procedure of the dbms_java package, like SQL> BEGIN 2 […]

Hidden DBMS_JAVA Nuance
Fri, 21 Mar 2014 06:44:53 +0000
It always happens when I’m in a hurry. Yes, I ran into one of those pesky little features with Oracle’s DBMS_JAVA package. While I try to write entries with proper GeSHi case semantics, like everyone else I tend to write PL/SQL initially in lowercase. That led me to the discovery of this wonderful error message: […]

Deprecated mysqli Functions
Tue, 18 Mar 2014 18:28:36 +0000
Having noticed the release of PHP 5.5.10 last week while I was speaking at UTOUG, I checked the deprecated mysqli functions web page. There weren’t any deprecated by 5.5. Unfortuantely, there were six mysqli functions deprecated in 5.3 and removed in 5.4. Unfortunately, many of my posted code examples use 5.2 or 5.3 where they […]

Author Profile
Name: Michael McLaughlin
Location: Rexburg, ID

Website: Oracle Press Books

Copyright © 2013 McGraw-Hill Global Education Holdings, LLC Any use is subject to the Terms of Use and Privacy Notice