Valid For

Extract and Replicat

Description

Use the MACROCHAR parameter to change the macro character of a macro definition to something other than the # character. You might need to change the macro character when, for example, table names include the # character.

The MACROCHAR parameter can only be used once in the parameter file. Place the MACROCHAR parameter before the first MACRO parameter in the parameter file. Anything in the parameter file that begins with the specified macro character is assumed to be either a macro or a macro parameter. All macro definitions in the parameter file must use the specified character.

MACROCHAR cannot be used with query parameters.

See also "MACRO".

See the Administering Oracle GoldenGate for more information about using macros.

Default

# (pound symbol)

Syntax

MACROCHAR character

character

The character to be used as the macro character. Valid user-defined macro characters are letters, numbers, and special characters such as the ampersand (&) or the underscore (_).

Example

In the following example, $ is defined as the macro character.

MACROCHAR $
MACRO $mymac
PARAMS ($p1)
BEGIN
col = $p1
END;