PLS-00801: internal error [hshuid:LU invalid] when compiling a package body

This was a strange one.  Attempts at recompiling the following package body resulted in this PLS-00801 error. COL owner FOR A20 COL object_name FOR A40 BREAK ON object_name SELECT owner, object_name, object_type, status, created, last_ddl_time FROM dba_objects WHERE object_name = 'PKG_FINANCIALS_WORK' ORDER BY status, object_type / OWNER                OBJECT_NAME    


Real Time Ambient Display at OpenWorld: The Software (for the Hardware)

This is part 2 of my blog post series about the Ambient Visualization hardware (part 1).  Also, please read John’s post on details about the creation of the actual visualization, from concept to build.  In the first part, I focused on the hardware, a sonar sensor connected to a NodeMCU.  In this second part, the focal point will be the software.

When I started working with ESPs a few years ago I was all (more...)

Real Time Ambient Display at OpenWorld: The Hardware

As John mentioned in his post, one of the projects I worked on for OOW16 was the devices to provide the data to his Ambient Display.  Unlike previous years, where we record attendance and then produce a report a few days or weeks after OOW, Jake proposed that we’d somehow visualize the data in real-time and show it to the attendees as they are producing the data themselves.

In order to produce the data, we wanted to strategically (more...)

My First Oracle OpenWorld

This year I had the great opportunity to attend in person Oracle OpenWorld 2016 and JavaOne 2016. Since I was student, I heard how fantastic and big is this conference but you cannot realize it until you are in it.

All San Francisco is taken by a bunch of personalities from all companies around the world, and it’s a great space to talk about Oracle, show off our projects and of course, our vision as (more...)

“I Appreciate You”

Today, October 11, 2016, is OTN Appreciation Day. In honor of that I wanted to post my favorite offering from Oracle — Exadata. Yes, I’m biased but even at that the Exadata platform is an outstanding offering from Oracle. Let’s look at some of the ways Exadata provides performance and value.

Exadata is an engineered system, meaning that all of the components are selected and configured to work together to provide performance. Part of that (more...)

OTN Appreciation Day: PL/SQL

We are posting these blog posts today as part of the OTN Appreciation Day, a celebration for the Oracle Technology Network as suggested by Tim Hall, inspired by Debra Lilley.

The mission was not too hard: write about your favorite bit of Oracle Technology.

As a developer and a core-tech DBA and APEX enthusiast… the choice was easy! PL/SQL (apart from how it is pronounced or even written ;-)!

Why? Easy!

Not just because (more...)

How I Attended Oracle OpenWorld 2016

OK, it wasn’t me exactly. It was more like some of my software-based representatives.

Hi, I’m Ed (@edhjones). And I’m not one of the AppsLab folks. But I’m always interested in the work they do, so I try to hang out with them whenever we’re co-located. I was intrigued then when, a couple of months prior to OOW16, I get a mail from Jake (@jkuramot) CC’ing Raymond (@yuhuaxie). It (more...)

My life as a (telepresence) robot


Left: Double 2. Right: Beam

We have been quietly observing and evaluating our options before we finally decided to get a telepresence robot. Telepresence technology dates back to 1993 (Human Productivity Lab) and telepresence robots are not completely new.

There is a growing array of telepresence robot options (see comparison) and the list is bound to get cheaper and better. Before we settled on getting the Double Robotics robot, we tested the Suitable (more...)

#OOW16, San Francisco, looking back

In this post I just wanted to highlight a few things that have lingered with me since the 2016 Oracle Open World Experience.

Persistent DRAM
Now, here, being at home, I must admit that I cannot find very much documentation about this, but it got me thinking… A little paradigm-shift, where computers actually wouldn’t need moving parts anymore (ie. disks of any kind). Create devices that use these memory structures, quite possibly combined with flash-disks, (more...)

Our Real Time Ambient Display at OpenWorld

One month before we entered the Exchange Tent at OpenWorld, Jake challenged us to come up with a visualization “that would ambiently show data about the people in the space.”

A view of the Apps UX Exchange Tent at OpenWorld 2016

A view of the Apps UX Exchange Tent at OpenWorld 2016


Mark and Noel and I accepted the challenge. Mark put together the Internet of Things ultrasonic sensors, Noel created a cloud database to house the data, and it fell to me to (more...)

#doag2016 my picks and suggestions

As many conferences evolve over the years, the number of sessions on offer can easily be overwhelming. I have overheard many conference attendees wrestling with their choices for what to see and which sessions to attend.

For DOAG 2016 I have a short overview with my picks and with one or two tip-sessions. I hope this helps, though it is just my personal preference of course…

Please note that this post is based on the (more...)

Fun, Games and Work: Telepresence Robots

Companies talk about “Gamification,” but the first time I felt like I was playing a game at work was driving our Double telepresence robot around the office floor, rolling down the hallway and poking into cubicles. With a few simple controls—forward, backward, left, and right—it took me back to the D-pad on my NES, trying to maneuver some creature or robot on the screen and avoid obstacles.


It’s really a drone, but so much less (more...)

“My Kingdom For A Histogram”

"Don't you know anything at all about numbers?"
"Well, I don't think they're very important," snapped Milo, too embarrassed to admit the truth.
"NOT IMPORTANT!" roared the Dodecahedron, turning red with fury.  "Could you have tea for two without the two, or three blind mice
without the three? Would there be four corners of the earth if there weren't a four? And how would you sail the seven seas without
a seven?"

IoT Workshop Guide – part 2

In last p`ost, we have setup development environment for coding and uploading scratches to NodeMCU, an IoT device.

This post, we will upload and run two examples to demonstrate how IoT device sending data into Cloud and receiving commands from Cloud.

4. Architecture Diagram

It involves several tiers and components to make the whole IoT loop. However, you will just focus on device communication with MQTT, all other components have been setup properly.



5. (more...)

IoT Workshop Guide – part 1

AppsLab and OTN will jointly host IoT Workshop at Oracle OpenWorld and JavaOne conference in 2016. We look forward to seeing you at the Workshop.

Here is some details about the Workshop with step-by-step instructions. Our goal is that you will learn some basics and get a glimpse of Oracle IoT Cloud Service at the workshop, and you can continue playing it with IoT package after going home. So be sure to bring your computer (more...)

For OpenWorld and JavaOne 2016, An Internet of Things Workshop


Want to learn more about the Internet of Things?

Are you attending Oracle OpenWorld 2016 or JavaOne 2016? Then you are in luck! Once again we have partnered with the Oracle Technology Network (OTN) team to give OOW16 and JavaOne attendees an IoT hands-on workshop.

We will provide a free* IoT Cloud Kit so you can get your feet wet on one of the hottest emerging technologies. You don’t have to be an experienced electronic engineer to (more...)

A Bloomin’ Mess

'Why is it,' he said quietly, 'that quite often even the things which are correct just don't seem to be right?'
-- Norton Juster, The Phantom Tollbooth

For some time now Oracle has used bloom filters to speed the processing of select statements; unfortunately in converting a select statement that uses a bloom filter into an ‘insert into … select’ form causes Oracle to abandon the bloom filter altogether. Let’s (more...)

Oracle Open World 2016 – What GoldenGate sessions are there?

Well, it is that time of year again; the streets of San Francisco will be crowded with members of the Oracle community! As everyone in the Oracle community descends onto the bay area, there will be excitement about the things that will be announced this year. Sure a lot of it is going to be about “cloud” and what direction Oracle is taking with their “cloud” strategy. Besides, “cloud” there will be a lot of (more...)

Being An ACE – What’s In It For THEM?

I’ve been an Oracle ACE for about 7 years now, and have never written about it. Other Oracle ACEs have written about this over the years (like this post by Tim Hall), so I didn’t feel the need to write my own post. Lately, I’ve been thinking about the Oracle ACEs from a different perspective, … Continue reading Being An ACE – What’s In It For THEM?

Oracle Volunteers and the Daily Minor Planet

“Supercharged Perseid Meteor Shower Peaks This Month” – as the very first edition of Daily Minor Planet brought us the news on August 4th, 2016.

Daily Minor Planet

First edition of Daily Minor Planet

Daily Minor Planet is a digital newspaper on asteroids and planetary systems. It features an asteroid that might fly by Earth for the day, or one of particular significance to the day. Also it features a section of news from different sources on the topics (more...)