view counter
Home

APEX Feed

Oracle Application Express (APEX) resources, news, and support articles.

Flexible AJAX Calls In APEX – Reports

Started to get fed up sticking the same old javascript in my HTML header on lots of pages so I decided to make my report refresh call a little more generic… now I can just have it in my general JS library and call it however I want… This is used with a background report [...]

May 10, 2009 11:28am

More APEX Fun!

It’s been instructive to observe our progress as a creative group at Oracle as we strive to integrate our video department into the creative work process.

May 10, 2009 9:40am

Hello world!

Well this is my first post. The aim of this blog is to share tips and tricks in SQL tuning, PL/SQL programming and APEX development in Oracle. I will be posting as I come across things in my day-to-day work and also documenting some things that I’ve already been doing for a while. This blog [...]

May 10, 2009 9:16am

Oracle Application Express

Although Oracle Application Express has excellent out-of-the-box options for authenticating users, it is sometimes necessary to write custom authentication schemes to meet specific requirements. Such was the case for one client I worked with, a large government contractor with several Oracle Database instances already deployed and some fairly restrictive requirements, specifically

 

May 07, 2009 10:57am

Locating a Corrupt PDF (or many types of corrupt files) in a BLOB

I recently had a client pose the following question to me.

We have a system that generates pdf's based upon data from our Oracle database. The pdf's are then stored in a BLOB column in a table. We recently realized that at least one of those pdf's was corrupt. Is there a way within Oracle to determine if others are corrupt?

May 06, 2009 1:57pm

Twitter, Microsoft And Oracle?

Apparently where there's Tweets, there's fire. Twitter may or may not have a business model (management claims it does), but traditional software vendors are apparently convinced there's money to be made in them thar' streams.

May 03, 2009 10:31am

Oracle SQL Delimiter

It's been a while since I made a real post, one that has some technical merit. This one just barely qualifies.

There is a nice classic report type "Function Returning a SQL Query" which allows you to write a block of code that returns a select statement. That select statement is the basis for the report. I often use it to simplify building a where clause. It might look something like this:

declare
l_q varchar2(32767); -- This is the return variable. It will hold a select statement

begin

May 02, 2009 10:12am

Heading out to Collaborate 09

Just a few more hours and then I’m heading out to Collaborate 09. In a break with tradition I’m actually flying out a bit later than usual and flying back a bit earlier (pressure of work and all that!), but I’m looking forward to it immensely.
If you’re looking for information about APEX sessions at Collaborate, [...]

May 02, 2009 12:58am

Returning a Value from a Popup Page

I just ran into a situation where I needed to pass back a value from a pop-up page to a tabular form item in the calling page. While I've done this in the past by manually writing all of the JavaScript, I thought that I'd take a look at the new documented APEX JavaScript APIs.

I came across this function in the APEX 3.2 API Reference Guide (Part #E13369-01):

To read the entire article at its source, please refer to Returning a Value from a Popup Page

Apr 30, 2009 5:55pm

Heap size nnnnnK

ately I'm working a lot with XDB.
At the same time, having some spare time to investigate a few outstanding "issues", i decided to search the web for information about alert log messages like the following:

Apr 30, 2009 5:48pm
view counter