Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Other Syntax Segments > Identifier >

Using ON, OFF, or PROCEDURE with TRACE

If you define an SPL variable called on, off, or procedure, and you attempt to use it in a TRACE statement, the value of the variable is not traced. Instead, the TRACE ON, TRACE OFF, or TRACE PROCEDURE statements execute. You can trace the value of the variable by making the variable into a more complex expression.

The following example shows the ambiguous syntax and the workaround:

DEFINE on, off, procedure INT;

TRACE on;                     --ambiguous
TRACE 0+ on;  --ok
TRACE off;                    --ambiguous
TRACE ''||off;--ok

TRACE procedure;  --ambiguous
TRACE 0+procedure;--ok
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]