msgbartop
News, views, tips and tricks on Oracle and other fun stuff
msgbarbottom

SQL Developer/APEX Listener Bug and The Power of Social Networking in Action

Have you installed or recently upgraded to Oracle APEX Listener 2.0? Have you used SQL Developer 3.2 to manage APEX Listener settings? If you answered yes to both questions then you are in for an unwelcome surprise.

The surprise is that you’ll get a “500 – Internal Server Error” whenever you upload a file via any of your APEX apps or import files via the APEX Application Builder.

Kris Rice responded to my tweet almost immediately.

The problem was a bug in the way SQL Developer uploads APEX Listener settings to the server.

This Oracle forum post describes how to reproduce the bug and the workaround to fix it.

Kris quickly put a fix together and checked it in for the next patch.

icap

sqldev

If you are still hesitant to join Twitter, I hope that this post has given you an incentive to join this growing social network. Many Oracle employees, like Kris, are active on Twitter and listening to people like you and me who use their products on a daily basis.

To make it easier for you to follow Oracle people on Twitter, I have created this Oracle list. The list occupies a permanent column on my Tweetdeck stack.

1 Comment | Filed in Oracle | Tags: ,


Event-based Scheduler Jobs and Oracle Streams Advanced Queuing: A Powerful Combination

Problem:

An external or internal application wants to send inbound data to your Oracle database, like for example a purchase order or a receivable invoice. You want to consume this data in real time.

Assumptions:

The version of your Oracle database is 11gR2 or above. The only “tool” you have is the Oracle database, i.e. you do not have any middleware (like SOA suite) installed. The external or internal application can connect to your Oracle database.

Solution:

Use Oracle Streams Advanced Queuing (AQ) for messaging. Use an event-based scheduler job for real time data consumption. Both are standard features of the Oracle database.

Implementation Steps:

The following is a fully functional example of the solution, starting from creating a new database user and ending with consuming the message in the database.

Continue reading…

Comments Off | Filed in Oracle | Tags: ,


Video Montage of Oracle ACE Directors

Todd Trichler (@otnTodd) created a video montage of a bunch of Oracle ACE Directors. Ever wonder what an Oracle ACE Director is like? Check out the video below. I make an appearance at 4:02 minutes.

Bonus footage of the Oracle ACE Program wranglers Vikki Lira and Lillian Buziak (@oracleace) discussing the program.

Continue reading…

Comments Off | Filed in Oracle | Tags:


Oracle OpenWorld 2012 – Latest and Final News (Oct04)

Selected tweets, videos and photos from the last two days of Oracle OpenWorld 2012:

Continue reading…

1 Comment | Filed in Oracle | Tags:


Oracle OpenWorld 2012 – Latest News (Oct02)

Selected articles, tweets, videos and photos from Tuesday’s events:

Continue reading…

Comments Off | Filed in Oracle | Tags:


Oracle OpenWorld 2012 – Latest News (Oct01)

Selected articles and tweets from Sunday and Monday’s events:

Continue reading…

Comments Off | Filed in Oracle | Tags:


Oracle ACE Director Product Briefing 2012 – Day 2

Here is what happened today during the briefing:

Continue reading…

Comments Off | Filed in Oracle | Tags: ,


Oracle ACE Director Product Briefing 2012 – Day 1

Here is the story:

Continue reading…

Comments Off | Filed in Oracle | Tags: ,


How Big Will Oracle OpenWorld Be This Year?

One of the world’s largest technology conferences is going to start shortly. Oracle OpenWorld 2012 will officially kick off this Sunday, September 30. I will be attending and hope to see you there.

Last year’s event hosted more than 45,000 registered attendees from 117 countries. With eight new acquisitions so far this year, I expect the 2012 event to be even bigger, more than 50,000 attendees and 2,000 sessions.

Continue reading…

Comments Off | Filed in Oracle | Tags:


Oracle Magazine Ask Tom Columns, the Whole List ↗

Dating back to January 2001.

Comments Off | Filed in Oracle | Tags: