Oracle APEX Error ERR-7620

Recently got this error in APEX : Expecting p_company or wwv_flow_company cookie to contain security group id of application owner. Error ERR-7620 Could not determine workspace for application ().

[Read More]

Oracle APEX 4 Quick Reference

Oracle Application Express (Oracle APEX) is a rapid web application development tool which uses the Oracle Database. This article summarises the resources you need to use it effectively.

[Read More]

APEX Built In Substitution Strings

Application Express includes a list of built-in substitution strings. These can be used in HTML regions or blocks of PLSQL code. This article lists all the substitution strings.

[Read More]

SQL Script For Tablespace Utilisation

This query will give you a basic report on the bytes used and bytes available in the Tablespaces within a particular schema. I have used it within Oracle APEX but it can be used elsewhere.

[Read More]

Read Only Based On Authorization Scheme

In APEX it is easy to make an item read-only based on a predefined Authorization Scheme.

[Read More]

Disable Apex Button On Mouse Click

In APEX it is nice to disable a button once it has been clicked. This can help prevent users clicking the button twice. You have to paste a simple piece of JavaScript into the Button's properties.

[Read More]

Custom Success Messages In APEX

Many standard APEX themes and templates contain a region where process success or failure messages are displayed. You can provide custom messages in this area using the apex_application package.

[Read More]

Customising APEX Interactive Reports

The Interactive Reports in Oracle Application Express (APEX) are extremely useful. If you need to tweak their styling but there are limited ways to do that from the interface. So how can it be done?

[Read More]

Set Reset Interactive Report Filters

Within the APEX APEX_UTIL package there are a couple of useful procedures for setting and resetting Interactive Report filters. This allows you to manipulate IR filters programmatically within PLSQL.

[Read More]

APEX Delete Confirmation Dialog Box

When you delete records from a record set in Oracle Application Express using a Delete button it is best to give the user a chance to cancel. This can be easily achieved using a JavaScript popup box.

[Read More]