8.47 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
See Also:
Parent topic: APEX_APPLICATION_INSTALL