Heading to ODTUG

The last days were a rush... a lot of meetings, everybody coming at the same time and next to that trying to get the deadlines in some projects... My blog was a bit silent, but that will change in the coming days!

Today I'm leaving for Kaleidoscope 07 (ODTUG), held in Daytona Beach, US.

It's not that easy for me to go there. I'm flying over Atlanta where I need to wait for over 6 hours for the connecting flight to Daytona Beach, but it will be worth it.

Last year I really liked ODTUG. It was at that time also my first time in the States. I blogged every day and will try to do that again now.

I hope there's some free wireless in Atlanta, so I can finish some blog posts I started.

I updated the Apex Meetup website with the date. We'll meet on Monday during and after the Welcome Reception.

Time to leave now...

Oracle Application Express (APEX) @ ODTUG

Following Oracle Application Express (APEX) sessions are scheduled at ODTUG...

It's a pity that some sessions are going on at the same time, but it's also a proof APEX is getting more known. Next to the two days APEXPOSED, there're 13 sessions dealing with APEX. Compared to last year that's a hugh increase!

Monday, June 18

APEXPOSED (whole day)
agenda: see website


Tuesday, June 19

APEXPOSED (whole day)
agenda: see website

Web-Based Applications Strategies from an Oracle Forms/Reports Developer's Perspective (11:00am - 12:00pm)
Wesley Brown and Krupa Ramachandran, St. Jude Medical Inc.
Future development tools present a quandary for companies who were geared heavily towards Oracle Forms/Reports. Strategies on how to keep currently deployed applications/reports up and running while deciding which Web tools to use and how to train developers to use them must be defined. Also, providing users with the same "Look and Feel" with a common point of access for both old and new Applications / Reports is a goal. We have taken a "transitional" approach as a solution. We chose to start with APEX and ASP.NET which we consider intermediate Web development technologies relatively easy to use with Oracle database yet powerful. Our developers have been successful in deploying new projects utilizing these environments and incorporating them into the traditional Application Launch interface with users unaware of which tool is being used. In this endeavor we have discovered how we can develop projects in several environments seamlessly without disruption of service to our customers and are taking steps necessary to fully utilize Web-based tools in the future.

APEX SIG MEETING (5:30pm - 7:00pm)


Wednesday, June 20

APEX Validation and Error Handling (8:30am - 9:30 am)
Patrick Cimolini, Cayman Islands Government
This presentation is a detailed discussion on how an Applications Express (APEX) application can be configured to handle both business rule violations and run-time errors. Business rule violations are detected in triggers and then raised to the GUI where the user is presented with a context sensitive message that contains the information that allows the user to correct the problem. Run-time and system errors are logged in the database and then passed up to the user. A professional validation and error handling strategy is a key component in building robust, user-friendly systems. The points will be illustrated using one of the presenter's production systems.

APEX Lessons from the Trenches (8:30am - 9:30 am - same time as previous)
Bill Holtzman, National Air Traffic Controllers Association
Application Express enables rapid and efficient development of secure and enterprise-level Web applications. Like any platform, there are numerous tricks of the trade that one learns only after getting waist-deep in the coding. The National Air Traffic Controllers Association (NATCA) has been digging successfully in the APEX gold mine for three years and has a wide assortment of coding techniques to share with those undertaking or considering expanding their use of APEX.

How to Make Your Oracle APEX Application Secure (9:45am - 10:45am)
Peter Lorenzen, WM-data
When you deploy an Oracle APEX application on the public internet you have to assess the level of security needed. If your application only contains non-sensitive data you may be able to deploy it in much the same way as you would on your intranet. However, if you need to secure your application, there are a number of things you need to consider. This presentation will explain some of the risks and how to minimize them. Some of the issues we will discuss are cross-site scripting, session state protection and SQL Injection. We will also look at some of the things you can do to secure an Apache HTTP Server.

Advanced Application Express Programming Techniques (9:45am - 10:45am)
Michael Hichwa, Oracle Corporation
Learn Michael Hichwa's perspective on how to develop Application Express (APEX) applications from data model to user interface. Get recommendations for source code management, upgrades, and customizations. See how to exploit new Oracle APEX 3.0 features. See techniques to improve and test performance.

Oracle Application Express 3.0—Introduction and New Features (11:00am - 12:00pm)
David Peake , Oracle Corporation
Oracle Application Express (Oracle APEX) is a Web-based, application development and deployment tool integrated with the Oracle Database 10g and Oracle Database 11g. Oracle APEX enables anyone with only a Web browser and limited programming experience to quickly create secure and scalable Web applications that can be instantly deployed to tens, hundreds, or thousands of users. This presentation and live demonstration positions the tool and provides an overview of its features and capabilities. We'll look at Oracle Application Express 3.0 new features, such as Flash Charting and PDF Printing and Reporting, discuss the future direction of Oracle APEX and show examples of why it is one of Oracle's most popular technologies.

Building an Application Express Interface to Organize Discoverer Workbooks (1:30pm - 2:30pm)
Jeff Hohman, Oracle Corporation
This session will provide users with an alternative to organize their workbooks using a somewhat open source solution. Because of the flexibility involved changes in the product can be easily compensated for, thus, making this add-on highly beneficial.

APEX by Example: Shared Components (2:45pm - 3:45pm)
Dimitri Gielis, Apex Evangelists/Ordina Belgium
Oracle Application Express (APEX) is a quickly growing development environment. The initial goal of APEX was to have something 'simple', a wizard-driven development environment to compete with MS Access or to replace Excel files. People still use the wizard a lot, but if you would really like to use the force of APEX,
you can use Shared Components. This session covers all available Shared Components; it tells you what it is for, why to use it, and how to use it in a real environment with the "DG Tournament" application.

APEX and Project Management (4:00pm-5:00pm)
Patrick Cimolini, Cayman Islands Government
Application Express (APEX) is a robust and productive development tool, however, even APEX projects can be late, over budget, and of dubious quality if they are not well managed. Looking at APEX from a project manager's perspective, the following questions are addressed: How long will a project take? What tasks needs to be done? How long will a single task take? When should the tasks be done and in what order? Who performs the tasks? What skills are required? How are source code and versions managed? What quality can be promised and delivered to the customer? Quantitative metrics and a production application will be used to illustrate the points.


Thursday, June 21

Managing Large Application Development Using Oracle Application Express (8:30am - 9:30am)
David Peake, Oracle Corporation
This presentation will outline developing large applications using Oracle Application Express (APEX). It will be based on personal experience managing a diverse team of developers and personally developing APEX Applications on a comprehensive system with close to 1000 individual applications. Development on this
application started over four years ago and has successfully been implemented as the primary enterprise-wide OLTP system for a large law enforcement agency with thousands of users.

APEX Cheat Sheet (11:00am - 12:00am)
Karen Cannell, Integra Technology Consulting
For beginner APEX users, and for those who have not yet memorized all the ins, outs, &’s and .’s, this cheat sheet session presents a collection of frequently used APEX features, expressions, how-tos, and assorted oh-yeahs to keep handy when building your first 2 or 22 APEX applications. We’ll cover the F$P syntax, report links, when to use &, :, v(), select lists, sending e-mail, popups, adding your own logo, custom authentication, and some essential JavaScript. You’ll leave this session with a cheat sheet of APEX how-tos that will get you well into APEX development.

Application Express for the Designer Web Generator Expert (1:00pm - 2:00pm)
James Hudson, Wisconsin DNR
Application Express is a natural successor to the Designer PL/SQL Web Generator. This presentation will show how to take an existing Web Generator Application and migrate it to run using Application Express. The goal, though, isn't simply to identify the steps in rebuilding an application in a new technology. We will also look at
ways to "think" in the APEX tool and use advanced features provided out-of-the-box by APEX. The session shows how Designer experts can pick up APEX fairly quickly and build new apps, convert existing apps, or integrate the two.

Flex Your APEX: Implementing Oracle E-Business Suite Flexfields in Application Express (2:15pm - 3:15pm)
Shane Bentz, InterVarsity Christian Fellowship/USA
With every passing day, the functional boundaries between traditional client-server applications and Web applications decrease. New technologies such as SOAP and Ajax enable Web applications to function and perform like traditional fat-client software. In this session, I will show how to integrate the E-Business Suite flexfield functionality into Application Express. By leveraging the power of Ajax, Application Express can use descriptive flexfields to create rich Web applications—applications that can change shape and purpose on-the-fly, enhancing the user experience by not reloading the page and minimizing future coding by developers.

Testing Oracle BI Publisher with APEX 3.0

In APEX 3.0 it's possible to print pdf's using an externally defined report server.

There's a good document on OTN to configure this printing feature in Oracle Application Express.

Below the steps I did with some screenshot and an example of the first PDF report I ran through BI Publisher:

1. Pre: I already have an Oracle Database 10.2.0.3 with APEX 3.0 installed
   
   -- BI Publisher part --
2. Download and install BI Publisher 10.1.3.2.1
3. Installation of BI Publisher was amazingly simple! After 6 minutes the Basic installation (on Windows XP - btw unsupported!) was done and my server was up-and-running.
4. Testing the installation by going to the url OUI specified at the end of the installation. On my laptop that's: http://digixp:9704/xmlpserver/
5. Logging in into BIP for the first time with Administrator/Administrator
   Go to the Admin link - JDBC connection - to add your database (see picture)
   
   -- APEX part: Configuration --
6. Login into the INTERNAL workspace
   
7. Click on Manage Service > Instance Settings > Report Printing
8. Put the details of the BI Publisher reporting server
   (see picture)
   
9. That's about it to configure it in the INTERNAL workspace
10. Logout
    
    -- APEX part: Report --
    
11. Login into your development workspace
12. To create my first report I went to the Sample appication
    > Page 3 > Products Report
13. Click on the Report link and go to the tab (from APEX 3.0 onwards): Print Attributes (see picture)
14. In this screen you can configure how your report will look like and make pdf printing possible for that report
15. Minimal you should:
    Set Enable Report Printing to Yes and give it a Link name
16. The rest of the options are also very useful and necessary to make the report exactly as you want it to look like
17. When running the page you'll see a Print link somewhere near the report (left picture)
    
18. Clicking on that link will give you a pdf that looks like your report (right picture)
    The report is not yet completely like I would have it to be (for ex. with pictures, nicer scaled, headers and footers), but that will be another post.
    
    
    

Reuse Oracle APEX Components

Not sure if you already saw this feature in Oracle Application Express?
"Export Application Components" (in Application Builder - Shared Components)


When I first saw it, I thought: "cool", I can export my Shared Components (or Reusable Components) and import it again in another project. But that's not completely true...

On the left, you see you can export almost every APEX component. On the right side you see the import functionality (Application Builder - Import).

So what's the problem?

Same Workspace - Same Application
There's no problem when you stay in your current application. You can nicely export and import components.

Same Workspace - Different Application
If you try to import the component in another application, you get an error (see below).
But isn't that strange? You can create a new item based on a copy of an existing item of another application. (This is also a workaround, although you would need to create a new item for every component you want to copy)

Different Workspace - Different Application
If you try to import the component in another application of another workspace, you get the same error (see below). There's no workaround for this, except to export the whole application from one workspace, import it again in the other workspace and create components as copies of the components of the imported application.

Life would be a lot easier to have the export/import functionality as it would allow to copy (and subscribe) more components at once.

The error you get when you're not in the same application while importing:

I like the feature, don't get me wrong, and I understand the difficulties of doing it (changing id's). Nevertheless I hope in APEX 3.1 or 4.0 it will be extended so it also works cross workspace/application.

In the meanwhile, if you want to reuse components, make a "Shared Application" and when you start a new project import the entire application into your workspace (if it's cross workspace).

Additional Skills to become an Oracle expert

In the last months I did some more non-Oracle certifications and trainings to broaden my knowledge.

Why should you follow non-Oracle training as an Oracle expert?

You can try to become the best Oracle developer or dba by learning a lot about the Oracle database and the (development) tools. Everybody sees added value into that, isn't it? The more you know of Oracle, the better you do your Oracle job? I think that's only partially true.

I believe having experience and soft skills are also important. Experience you can only build by doing your job and getting older (to bad ;-)). Some people have luck as they received at birth qualities that simplifies the learning of some soft skills, but even if you didn't receive it, you can still work on it. As a consultant for ex. effective communication, being creative and motivated, presentation techniques, customer oriented are skills that can be very useful.

Something else that I think will become more important are the use of methods or best practices in your job. A framework can simplify your life and also let you be more structured.

Some of the frameworks/methodologies I followed in the last months:

ITIL: IT Infrastructure Library

ITIL means IT alignment with the business. I think this could be an added-value for every DBA. I strongly believe that the role of an (Oracle) DBA will change in time. Or you become someone who will need to know the business and have an overview of the entire system for ex. with Oracle Grid Control, so you need to know a bit of everything. Or you need to become a real guru for the Oracle database as it's getting more complex. The database will do more and more things for you, but to understand what he's doing, you need to know a lot...

For the first group, ITIL can help a lot. Grid Control will be your Management Tool, but then when you suddenly get a red light! You have a problem... What will you do? How to handle it? How to do the follow-up? How to know it never happens again? And what will be the impact for the business?

How you can handle that process is described in ITIL.

I know a lot of "Service Desks" using/or being based on ITIL nowadays... I think a lot of organisations will organize some (IT) departments, so that would also impact you (as Oracle DBA).


For developers a useful method is PRINCE2.

PRINCE2

"PRINCE2 is recognised as a world-class international product and is the standard method for project management, not least because it embodies many years of good practice in project management and provides a flexible and adaptable approach to suit all projects. It is a project management method designed to provide a framework covering the wide variety of disciplines and activities required within a project. The focus throughout PRINCE2 is on the Business Case, which describes the rationale and business justification for the project. The Business Case drives all the project management processes, from initial project set-up through to successful finish."


As a developer life would be a lot easier when you would exactly know what you had to do. A lot of projects don't have a project manager (or project board). Is it always needed? No, I didn't say that, but for every project you should have somebody who does the role of a project manager.

When going through the PRINCE2 course/certification I found the set-up really useful. A project board with a Senior User, and Executive and a Senior Supplier. On the next level the Project Manager etc. A lot of projects are doing this maybe intuitively (I had that feeling), but having it on paper, made it more structured.

In PRINCE2 I saw the different Processes, Components and Techniques. When you, as a developer, knows about all these, the team becomes more powerful and can go a lot faster, I think.

APEX Forum - Week 21

My goal is to put some links to the forum that took my attention in the last week. Sometimes these posts made me laugh, sometimes they made me cry and some of them I found really interesting.

The most funny posts:

• APEX API - interface description: Some developers have a hard time to implement APEX in their environment. How secure do you want it to be?
• Windows Express 3.0 Bug?: Sometimes users are confused about names... APEX, XE, Windows, Oracle database, 10g some many words, so many differences
• Loading images!!!!: How to ask a question? Or better how not to ask a question! Ofcourse the message was clear, but why so many !!!
  

The most interesting topics:

• SOLVED - Apex + Cocoon = Blank Page?: Sometimes the solution is in the details
• Generate PDF report with HTML data: How to display the content of a CLOB field containing html tags correctly in a pdf generated by BI Publisher.
• Blog or Wiki applications built using APEX: Carl Backstrom started with a wiki application here, but it's not yet finished. I started with a blog application which you find here, also not finished yet.
• Cookies and sessions: Apps must belong to the same workspace in order to be able to share sessions.
• Using Oracle Text with Apex: Do you want to highlight your searched text, then have a look at this thread
  

Announcements:

• IE Developer Toolbar out of beta: Posted by Peter Lorenzen, you find the tool here
  

Tips:

• Date picker location: When you want to customize the calendar pop-up you can use a DHTML calendar as shown here
  
• Creating an index of all pages in the application: It shows again that the APEX dictionary is very powerful but not that known at the moment.
  

If you saw something in the forums I should have included, you're free to put a comment.

APEX podcast by LewisC

This morning I listened to a great podcast about APEX.

Lewis Cunningham interviewed David Peak, Application Express Product Manager from Oracle and Peter Martin, working for a company in the EMEA automotive industry and APEX user.

I took some notes... here they are:

What are the key features of APEX?

• Developing Secure applications is easy with APEX
• Declarative way of programming (using wizards)
  
• Built in Reporting, Forms, Charts, Pdf reports
• Possibility of using Webservices
• Upload spreadcheat
• Free
  

Why should we use APEX?

• Extreme Rapid Application Development (RAD)
• Completely web-based
• Very good tool to have immediate result, excellent in proto-typing
• You can start building apps in APEX next to the customer and agree on the layout (user sees what he gets), then start with the back-end.
  
• You only need a webbrowser to develop in APEX
  
• APEX development environment is built by itself, it's also completely meta-data driven and based on PLSQL
• Start with a design model and use the full potential of the Oracle database
• Free with the database (if you've an Oracle license)
• Free with XE, screens of XE are made with APEX (the APEX version of XE is different as the "normal/full" one)
  

How to compare developing in APEX with Ruby on Rails?

• Benefit by using APEX:
• Framework within Oracle database
• Integrated with the database (security, enterprise functionality, ...)
• Don't need to focus on connection pooling or typical java environment complexity
• Prototyping - RAD environment
• Completely Free

How is APEX used in your environment, Peter?

• About the company he's working for and how they use APEX
  
• EMEA, automotive industry
  
• Terrabyte database
• > 100 million records
• They use Discoverer but also want to go to APEX (internally)
• Integration with SSO, Forms
• Developing in APEX - the sky is the limit
• Reuse of their SQL/PLSQL skills without getting to know the java framework
  

What are the challenges when developing with APEX?

• Because it's so easy to develop
• Use a plan/proces to make a GOOD application
• Use the APEX framework as good (best) as possible
• Go to some Apex Evangelists trainings to learn how to best use APEX (joke, they didn't say that) ;-)
  

What is new in APEX 3.0 or are the highlights of this new version?

• Integration with BI Publisher
• Use of Flash Charts
• Webservice capabilities: talk to Oracle BPEL for ex.
• Navigation, improvement of UI
• Access migration workshop: from Access mdb file -> take export and migrate directly into Oracle
  
• -> SQL Developer: tables
• -> APEX: forms, reports
  

What are other strong points of (developing with) APEX?

• Strong user community and community feeling
• Forums are a great source of information, the APEX forum is the most used forum on OTN!!
• Also some good Blogs:
  
• Scott Spendolini
• Patrick Wolf
• Dimitri Gielis (hey I got mentioned!! thanks guys!)
  
• John Scott
• Integrating with Spatial, OLAP, E-business Suite
• 9 existing Packaged applications, new ones are in the pipe
• Designed to show how we do things
• Show a working solution
  

What about the future and the integration of APEX with SOA?

• APEX is not competing with J2EE
• APEX has also Webservices and can integrate with BPEL, SSO etc.
  
• APEX can be the glue between all your applications or an extension to an existing app
  
• When you have a lot of complex middle tier logic, Oracle provides J2EE for this
• Use the best tool for your team (if you've a lot of Java programmers, you can go for Java/SOA, in all other cases APEX is a possibility)
  

To conclude my notes, I found it an interesting podcast! Thanks Lewis...

I believe APEX is getting more popular!
Tom Kyte (and me too) says sometimes: "Every single day I learn something new"
If I change that a bit: "Every single day a new person gets to know APEX"

Asking direct questions

I already thought about it before and decided to finally do it after I read the System Stats strategy blog post of Jonathan Lewis. He states: "I don’t tend to respond to individual questions - it’s not an effective use of my time - so there has to be a good reason for replying."

Tom Kyte also stated here: "If the question comes in email and is very very easy/quick to answer - sometimes I'll supply the quick answer along with my standard "please don't email me directly" quote I have saved as a signature. I cannot do it via email - I'd get nothing else done."

In the last weeks I get a lot of direct questions about APEX in my mailbox. I don't mind questions, I really like them! It also shows that APEX is getting more used and it feels nice to get the recognition.

But the problem begins when you end up only answering questions from your mail ;-)
If I answer a question through mail, only one person learns from it, if I answer questions in the forum everybody with the same problem can read my answer.

I really would like to encourage people to post their questions in the Oracle Forums. Not only I'm answering some questions, but there're a lot more APEX specialists to answer them or who add their thoughts to the threads.
If you believe I'm the only person who can help you (which I doubt), you can add "to Dimitri: ..." in the forum.

When can you contact me directly?
- When you need direct support, but then it's better to contact consult@apex-evangelists.com
- When you think it's a nice question to blog about... So the direct questions I get, will probably become a blog post ;-)
- For questions about the APEX SIG, APEX meet-ups, Apex Evangelists, my presentations or personal questions

Thanks for understanding...

APEX Forum - Week 20

My goal is to put some links to the forum that took my attention in the last week. Sometimes these posts made me laugh, sometimes they made me cry and some of them I found really interesting.

The most funny posts:

• Application Express as front end: can APEX be used as the front-end for your Oracle database? Yeah right...
• Two times somebody confused John with Scott: European APEX Training and Using Word Verification On Registration Page
  

The most interesting topics:

• When users open links in a new window: no solution yet for the problem of mixing up data from one session and multiple data. Interesting to see how this evolves...
• how to create a workflow (not a wizard): if you want to see the flow of the process (different screens) there's an example in that thread
• How to use multiselect list in tabular form: this is not out-of-the-box, it needs some coding
• APEX and BPEL: two posts: here and here (no replies yet)
  

Announcements:

• New (updated) Discussion Forum packaged app: here
• Master-Detail PDF Report: how to and sample app
• ODTUG APEX Meet-up: during ODTUG Kaleidoscope we organized another APEX Meet-up
  
• European APEX Training: the first training organized by the Apex Evangelists in Brussels (September 4-6): direct link to the training information page here
  

Tips:

• A nice example page of the new Flash Charts in APEX 3.0
• All the APEX How to's: here
  

If you saw something in the forums I should have included, you're free to put a comment.

New Google Analytics Stats for this Blog

My Google Analytics account is also migrated to the new version (beta).
It's pretty cool to use GA, as you have a bit more information about your visitors...

The Dashboard
Track Clicks

I capture when somebody clicks to download my whitepaper, just to have an idea how many people are interested in that topic.
The below images shows how many times my whitepaper was downloaded (from my blog). If there're some direct links to my whitepaper, then they're not taken into account.

I like this new version of Google Analytics, but nevertheless I tend to keep my Statcounter stats too.

Announcing European APEX Training Days

APEX Evangelists, of which I am a co-founder, is very pleased to announce the general availability of our first Application Express European Training Days.

The 3-day course, covering many different advanced Application Express topics, will be held from the 4th to the 6th of September 2007 at the exclusive Le Plaza Hotel in Brussels (Belgium).

The training will be given by some of the most experienced APEX specialists in the world (and also perhaps a special 'mystery' guest speaker!), there will also be a lot of opportunity for Q&A and discussion about APEX. It will also be a great opportunity for people to meet others in Europe who are using APEX too.

For more details and to register for the training, head over to here
(direct link to the registration page here).

Oracle buys Agile

When I got this message in the mail: "Oracle Buys Product Lifecycle Management Leader Agile - Enables Oracle to Deliver Best-in-Class, Integrated, Enterprise PLM", I thought, waw that's cool!! Oracle is going into Extreme Programming...

But when I read further, I think this Agile company isn't the same as the Agile methodology which I blogged about a year ago.

If somebody else knows that this Agile company did make the Agile programming methodology, please put a comment.

AE @ ODTUG Kaleidoscope 07

From June 18-21 in Daytona Beach Florida, a new ODTUG Kaleidoscope Conference is hold.

Last year, my first time at this conference, I couldn't have dreamed about it... Everything is going so fast these days that before you know you're presenting on several conferences in the States ;-)

I'm giving the same presentation at this conference as I did at Collaborate 07; APEX by Example - Shared Components (in DG Tournament).

ODTUG is developer oriented where IOUG does it all. The Oracle Development Tools User Group (ODTUG) established Kaleidoscope as its flagship event with sessions covering all the practical technical information you need to excel in your job.

What can you expect at ODTUG Kaleidoscope?

• More than 125 Technical Sessions with handouts—real topics, with real information, for real developers. No hired presenters. No fancy footwork. Just genuine colleagues sharing practical information.
• Two full days of preconference Hands-on Training.
• Oracle product updates.
• A full-day Oracle Fusion Symposium.
• An Oracle PL/SQL Test-A-Thon, developed by Steven Feuerstein and packed with great prizes. The Test-A-Thon is sponsored by Quest Software and O’Reilly Books.
• A one-of-a-kind Install Fest, where you will learn from the "gurus" how to install and configure Linux to run Oracle 10g software.
• APEXposed, an ODTUG exclusive "Seriously Practical" training event on Application Express.
• Unprecedented opportunity for networking with colleagues and experts at organized functions, on-site SIG Meetings, and more.

It will be technical and in Daytona Beach... What do you need more to survive in today's fast-paced Oracle environment? ...
I know! ... Another APEX meet-up (and something else that gets announced soon)!
If you want to meet other APEX-lovers at ODTUG 07, subscribe on this page: http://odtug2007.apex-evangelists.com/

Hope to see you there!

APEX Forum - Week 19

My goal is to put some links to the forum that took my attention in the last week. Sometimes these posts made me laugh, sometimes they made me cry and some of them I found really interesting.

The most funny posts:

• BI solutions by apex: Funny the way that "brother" talks

The most interesting topics:

• Can the embedded PL/SQL gateway handle SSL?: and yes is the answer!
  
• Open Source Flash Tools: It started with regular Flash and ended up with a discussion about Adobe Flex. We at AE are trying to integrate Adobe Flex with APEX. A result of that should be available in three weeks.
• Ajax - Query by Example: another Denes Kubicek example of something that comes back regularly in the forums
• New How-to on using the XML DB HTTP Server for APEX: Peter Lorenzen created some nice documents about this topic in the APEX wiki
• If you've seen some more interesting topics, please let me know...
  

Announcements:

• None

Tips:

• STATIC vs STATIC2 in static LOV definition: One sorts values alphabetically (STATIC) and the other sorts in the order in which they are written (STATIC2)
  

APEX SSP - Duplicate Submission

When reading this thread on the APEX forums about Session State Protection in APEX, I found a good tip of Scott Spadafore.

I didn't use this feature that much before, but it can be really useful to prevent users submitting the page more then once (for ex. when they hit the back button)!

Here's a screenshot how it looks like in APEX (in the Attributes of your Page)

Possible values:

• Yes - Allow page to be re-posted
  
• No - Prevent page from being re-posted
  

APEX reports in SQL Developer

I just read Kris Rice blog about "New patch with APEX features".

Kris is all into SQL Developer. SQL Developer is a great tool (addition) for any APEX developer.
I use SQL Developer a lot... it prevents that you need to switch all the time between the Application Builder and the SQL Workshop in APEX.

Below the new APEX reports in SQL Developer (picture from Kris's Blog):

I suppose the reports are based on the APEX dictionary.
For ex. for Applications: see the APEX_APPLICATIONS view in the FLOWS_

As Kris stated: The only down side is that APEX 3.0.1 is required and it hasn't been released yet.

Without any promises of Oracle... I heard we can probably expect this new APEX version at the end of May/begin June time-frame.

APEX by Example: Shared Components (whitepaper)

As I already blogged before... a while ago I made a whitepaper about APEX Shared Components.
From that whitepaper I made a presentation for Collaborate 07. The picture below was taken by John Scott a few minutes before I started my presentation. You can download my whitepaper from the IOUG website or from the Apex Evangelists site here (pdf of 3MB compressed).


In July I'll present it again at ODTUG. I updated the whitepaper for Kaleidoscope 2007 (different lay-out, other images, less pages, ...). I'll make it available for you to download after the event.

I hope you enjoy the whitepaper (there're a lot of pages!). If you have some suggestions to make it better, please let me know.

APEX Forum - Week 18

My goal is to put some links to the forum that took my attention in the last week. Sometimes these posts made me laugh, sometimes they made me cry and some of them I found really interesting.

The most funny posts:

• ApEx vs ASP.NET AJAX: a discussion about what's better... the initial poster has also some things he would like to see improved.
• Authorization Scheme checking before login: Especially this sentence: "That loud noise you heard was me slapping my forehead and saying "D'OH"."
  

The most interesting topics:

• Export Excel instead of .csv: another way of implementing the export to Excel (via html tables instead of separated file) - thanks to Denes Kubicek for this package - now available unwrapped.
• Changing Icon in a Report using javascript: another test of Denes
• TRICK: Dynamic Item Help Text as Tooltip: instead of clicking on an item label to get help, this thread describes how to show the help as a tooltip.
• Handle ORA- errors: Already got a nice red box in APEX when an error occurred? this thread discuss how to solve that.
• No content in files through BI Publisher: some have problems with the integration of BI Publisher and APEX. Some hints in this thread.
  

Announcements:

• Standalone BI Publisher is now available for Windows: here
• Joel Kallman (APEX development team) becomes Oracle ACE: here
  

Change default (first) page in APEX

Having seen this question often (yesterday again in the OTN APEX forum) and having had the same problem when I first started with APEX, I thought to blog about it.

When you make your first application in APEX you typically have as default page 1 or the login page (101). If you want to change your default (first) page you need to have a look at three different places. Let's say we want to have page 9 as default page:

1) Application Builder > Your Application > Page 101 > Processes (Page Processing) > Login
Change Process to:

 wwv_flow_custom_auth_std.login(
   P_UNAME       => :P101_USERNAME,
   P_PASSWORD    => :P101_PASSWORD,
   P_SESSION_ID  => v('APP_SESSION'),
   P_FLOW_PAGE   => :APP_ID||':9'
   );

Whenever somebody logs in we want him to go to page 9.

2) Shared Components > Security > Authentication Schemes > Your Authentication
Change the Logout URL: wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:9

If somebody logged out, we set the default page to 9 as that's our default page.

3) Shared Components > Security > Edit Security Attributes
Change the Home Link to: f?p=&APP_ID.:9:&SESSION.

If no page is specified this is the page to go to for ex. f?p=100 means we're going to application 100 with as default page, the page specified in the Home Link. You can also reference this url by #HOME_LINK#.

Oracle Develop round-trip

This link at OTN shows you the details about the two day conference for Developers.

Sometimes I get the question: "What about APEX in the future?"

It's an interesting question and I'm part of a group of people writing an article about it. But if you look at this conference, you see that APEX is included in the agenda too. Have a look at Database Application Development. You'll see sessions about the SOA Suite, .NET, JAVA, Webcenter, but also APEX. I'm sure that when Oracle Database 11g get released, you'll understand that APEX will stay for a long time... In 11g you'll see APEX 3.1 with a lot of web 2.0 enhancements next to some other improvements. 11g with APEX out-of-the-box will rock, my dear friends! ;-)