Sumner Technologies Blog

See Sumner Technologies Presentations at Oracle Open World

Scott Spendolini — 2009-09-27 09:00

Sumner Technologies will be presenting several times during this year's Oracle Open World. Here's a quick rundown of the presentations topics, times & locations:

The Evolution of ODTUG.com (S312595)
Sunday, 1:00PM PDT, Moscone West L3, Room 3016
ODTUG/IOUG Ask the Experts Panel (S312273)
Sunday, 3:30PM PDT, Moscone West L3, Room 3016
Performance Tuning Oracle APEX Applications (S309586)
Monday, 2:30PM PDT, Moscone South, Room 252
Troubleshooting APEX (S309516)
Monday, 4:00PM PDT, Hilton Hotel, Franciscan A/B
Replicating NetFlix Queue Drag-and-Drop Functionality with Oracle APEX & jQuery (S307614)
Tuesday, 1:00PM PDT, Moscone South, Room 236
Extreme Makeover: APEX Edition (Unconference Presentation)
Tuesday, 3:00PM PDT, Overloook I

We hope to see you there!

Sumner Technologies to Present and Exhibit at VOUG 2009

Scott Spendolini — 2009-09-02 07:40

Sumner Technologies will be both presenting and exhibiting at the Virginia Oracle Users Group (VOUG), which will be held on October 27th & 28th at the Richmond, Virginia Omni Hotel. Both Scott Spendolini & Doug Gault will be presenting at VOUG, with Scott presenting Troubleshooting Oracle APEX and Extreme Makeover: APEX Edition and Doug presenting Performance Tuning Oracle APEX Applications. If you plan on attending, please stop by our booth to say hello!

Still Time to Sign Up for Oracle APEX Online Training

Scott Spendolini — 2009-08-17 01:57

There's still a couple of weeks left before we start our next batch of Oracle APEX online training classes. There are spots in all five classes - Intro to APEX I & II, Intermediate APEX, Troubleshooting and Debugging APEX & Performance Tuning APEX.

All classes are taught online via toll-free number and web conference. You will get an electronic copy of all associated training materials, including the slides & workbooks used in the class. Online classes are also held for only 4 hours a day, so that you don't have to miss a full day of work to attend. And since we offer a toll-free number, you can take the training from home, where you're less likely to be interrupted.

More details can be found here: http://sumnertechnologies.com/training

Five New Online Oracle APEX Classes Just Added

Scott Spendolini — 2009-07-14 05:39

We're happy to announce that we have just scheduled five online Oracle APEX training classes:

Introduction to Oracle APEX I - August 31st, 2009 (five 4-hour sessions)
Introduction to Oracle APEX II - September 9th, 2009 (three 4-hour sessions)
Intermediate Oracle APEX - September 28th, 2009 (five 4-hour sessions)
Troubleshooting & Debugging APEX - October 6th, 2009 (two 4-hour sessions)
Performance Tuning APEX Applications - October 20th, 2009 (three 4-hour sessions)

Our online training sessions are conducted over a web conference and toll-free phone line, so you can take them at work or home. All sessions are taught live by our same great instructors who conduct on-site classes. Each session will begin at 12:00 PM ET and run for approximately four hours.

There are currently seats available in all of the above courses, but we anticipate them to fill quickly. Click on either course name for more information, pricing and real-time availability.

Plus, if you register more than one student from your organization by August 15th, 2009, each student will receive a 10% discount.

Oracle APEX Developer Competition Announced

Scott Spendolini — 2009-07-03 06:07

At ODTUG last week, Oracle announced the 1st APEX Developer Competition. Here's a summary of the rules, taken from Oracle's site:

Entry is open to any members of the Oracle Technology Network (OTN), except for employees of Oracle and its subsidiaries and the judge's companies.
You must be registered on the Oracle Technology Network (OTN) in order to enter the competition,
You can only submit one APEX application.
Submissions must be entered into the APEX Competition Application by 17:00 Eastern US Daylight Time (EDT = GMT - 5:00 hours) on 24 August, 2009.
{APEX Competition Application available after accepting the APEX Competition Legal Agreement and registering}
Submissions are final, and late or duplicate submissions will not be accepted, unless additional submissions are requested by Oracle.
APEX applications must be provided as a single Packaged Application including necessary supporting objects.
The primary language for your APEX application must be English, including supporting documentation. Optionally, you may also include other translated language versions of the application.
The judges decision is final.

Prizes include a free pass to Oracle Open World 2009 and free copies of Pro Oracle Application Express.

More information and detailed specifications for the project can be found on Oracle's site here:

http://www.oracle.com/technology/products/database/application_express/html/competition.html

APEX Remote Debugging - Revisited

Doug Gault — 2009-06-26 03:16

I'm sure that by now most people are familiar with David Peake's article called The Power of Two, in which he outlines how to remotely debug PL/SQL code that is executed by calling an APEX page. But I learned something new about remote debugging with APEX while at the ODTUG Kalaidoscope conference that I was not previously aware of.

David's article states that, with the correct grants, and by surrounding the code you want to debug with

dbms_debug_jdwp.connect_tcp('localhost',4000);
...
dbms_debug_jdwp.disconnect;

you can use SQL-DEVELOPER to remotely connect to the session and step through the code.

So, the thing I learned is that if you use the word "REMOTE" in the DEBUG position of the URL, APEX will automatically surround calls to stored PL/SQL code with the appropriate dmbs_debug_jdwp calls so that you don't have to alter your code.

This may be something that I just missed, but even after Googling it, I only came up with a couple hidden mentions. Either way, I figured it was worth posting just in case someone else had missed it too.

ODTUG 2009 Presentations Now Online

Scott Spendolini — 2009-06-25 03:31

All of our presentations from ODTUG 2009 are now online and can be downloaded here.

Here's a list of them:

Extreme Makeover, APEX Edition by Scott Spendolini
Many to One: Managing Multiple APEX Applications as One by Scott Spendolini
Oracle Application Express for the iPhone by Brian Spendolini
Performance Tuning Oracle APEX Applications by Doug Gault
You Can't Do THAT with a Browser - Version 2 by Scott Spendolini

You'll need a SumnerTech account to download any of them. They are free, and you can sign up for one here.

Voting Time at Oracle Mix Vote-A-Session...

Doug Gault — 2009-06-16 05:25

I believe last year was the first year that Oracle allowed the user community at large to choose some of the presentations that were to be given at Oracle Open World. They did so via Oracle Mix, and it looks as if they are doing the same again this year.

In I've just been informed that my presentation Replicating NetFlix Movie Queue Drag & Drop functionality with APEX and jQuery has been added to the list over at the Oracle Mix Vote-A-Session web site.

Here's the abstract...

While APEX allows you to create very robust web based applications in a very short timeframe, there are areas where the UI can be extend into the realm of Web 2.0.

jQuery is one of the most popular open source JavaScript libraries, and can be used to add very sophisticated user interface functionality to web based applications. To demonstrate this functionality the presentation will show step-by-step how APEX and jQuery can be used to fairly easily duplicate the functionality of the NetFlix Movie Queue.

Attendees will walk away with an understanding of the basic structure of the jQuery library, how it can be integrated into APEX and used to implement some very impressive interface techniques.

So, if you're interested in taking the APEX UI a little bit further with the help of some cool and relatively easy to use JavaScipt, then go and VOTE!

See "Many to One" at GROUG in Richmond, VA on August 12, 2009

Scott Spendolini — 2009-05-18 12:00

If you missed Scott Spendolini's presentation "Many to One: Managing Multiple APEX Applications as One", then you have another chance to see it at the Greater Richmond Oracle Users Group meeting on August 12th, 2009.

This session will outline and demonstrate a number of different APEX features and techniques that when combined, can provide a robust, single point of user access management for a suite of APEX applications — all without the addition of any middle-tier or single sign-on software. The session will also include demonstrations of all topics discussed.

More details can be found on GROUG's site here.

Visit Sumner Technologies at ODTUG Kaleidoscope

Scott Spendolini — 2009-05-11 12:00

Sumner Technologies will be not only presenting at this year's ODTUG Kaleidoscope conference, but will also have a booth in the exhibit hall. If you're planning on attending, please stop by to register for some exciting giveaways.