Archive for September, 2012

Viewing APEX Mail Log and Queue

Posted: September 28, 2012 in Oracle APEX
Tags: ,
Run these from APEX SQL Workshop:

SELECT * from APEX_MAIL_LOG ORDER BY LAST_UPDATED_ON DESC;

The next one will normally be empty, unless just prior to a queue purge (every 15 min?) or an error happened, then it will be retried 10X before finally being purged:

SELECT * from APEX_MAIL_QUEUE ORDER BY LAST_UPDATED_ON DESC;

PL/SQL Compiler awesomeness in action

Posted: September 28, 2012 in PL/SQL
Tags: , ,

The PL/SQL package compiler, being awesome, will happily compile the following line of code in your package spec:

MY_CONST CONSTANT VARCHAR2(5):='More than 5 characters';

despite the fact that the constant value is significantly longer than 5 characters in length. (more…)

Oracle APEX, being much smarter than you (and me, and the rest of the software development community), won’t allow you to do something crazy like exporting components, i.e. one or more pages, from one workspace, let’s call it DEVELOPMENT, to another called, for instance, TEST. (more…)

APEX JavaScript Hide/Show

Posted: September 28, 2012 in Oracle APEX
Tags: , ,
These functions will allow you to hide and show DOM objects like regions or buttons, as opposed to simply toggling their visibility, which may not collapse the empty space. Be sure to give the objects static IDs

$x_Hide('<DOM object name>');

$x_Show('<DOM object name>');

When publishing your form, if you get a message such as this:

infopath not accessible

maybe there is a connectivity issue, or maybe you are logged in as a different (test account?) user in the browser, one that doesn’t have access to the Form Library.

The local directory for Silverlight client components:

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS\ClientBin

Components available (highlighted components are part of the Silverlight Tooklit):

sharepoint client assemlies

On occasion, especially after deleting content from an InfoPath form, there will be whitespace at the end of a form that cannot be removed by deleting extraneous LF/CR characters that may still be present. One possible solution to this behavior is to inspect the Height properties of your layout table, and make sure that the offending row height is set to “Automatically Set Row Height”, instead of an absolute height.

I ran into an odd problem today, consisting of the symptoms described in the title above, after receiving a Windows Update pushed out by our corporate desktop management tools.

I’m not at all sure that the behavior was caused directly by the update, but what happened was that, after rebooting, evidently the nVidia video driver failed to load (Code 22 in Device Manager). When this happened, the video card defaulted to VGA mode, which triggered this seemingly random set of symptoms to occur.

Unfortunately, due to the highly managed environment and my lack of administrative access, I could not dig deeper into the problem to identify the root cause. Ultimately, I was able to fix it by running the “powercfg.cpl” through an Elevated Privileges Command Prompt, which allowed me to re-enable the video device. On restart, it was OK.

If you are using the Content Query Web Part​ (CQWP) to aggregate tasks from multiple sites, the AssignedTo filter field will disappear if the underlying field is changed to allow multiple users. The classic scenario for doing this is creating a “My Tasks” view, which works fine with single assignees.

This behavior can be particularly perplexing if you configure the CQWP with single users, and then later change the content type to allow multiple assignees. (more…)

1. Create Solution

2. Add Silverlight project, do development

3. For testing, add SharePoint Module type project, configure for sandbox

4. Add a document library to the project, if you don’t have a place to use already. (more…)