| Previous | Next |  | Contents | Index | Glossary

## Test

PL/SQL Syntax

`function Test`

         (p_event_name in varchar2) return varchar2;

Description

Tests whether the specified event is enabled and whether there are any enabled subscriptions by the local system referencing the event, or referencing an enabled event group that contains the event. Test() returns the most costly data requirement among these subscriptions, using the following result codes:

- NONE--No enabled local subscriptions reference the event, or the event does not exist.

- KEY--At least one enabled local subscription references the event, but all such subscriptions require only the event key.

- MESSAGE--At least one enabled local subscription on the event requires the complete event data.

Arguments (input) | p_event_nameThe internal name of the event.

| Previous | Next |  | Contents | Index | Glossary