SET_OFFSET Procedure

6.40 SET_OFFSET Procedure

This procedure sets the offset value used during application import. Use the offset value to ensure that the metadata for the Oracle APEX application definition does not collide with other metadata on the instance.

For a new application installation, it is usually sufficient to call the generate_offset procedure to use APEX to automatically generate this offset value for you.

Syntax

APEX_APPLICATION_INSTALL.SET_OFFSET (
    p_offset IN NUMBER )

Parameters

Parameter	Description
`p_offset`	The offset value. The offset must be a positive integer. In most cases you do not need to specify the offset; instead, call `APEX_APPLICATION_INSTALL.GENERATE_OFFSET` to generate a large random value and then set it in the `APEX_APPLICATION_INSTALL` package.

Example

The following example generates a random number from the database and uses this as the offset value for app 100.

DECLARE
  l_offset number;
BEGIN
  l_offset := dbms_random.value(100000000000, 999999999999);
  apex_application_install.set_offset( p_offset => l_offset );
END;
/
@f100.sql