Name
log_text — inserts statements into the roll forward log
Synopsis
log_text
(
|
in text varchar , |
| in arg_1 any , | |
...
); |
Description
The log_text function can be used to insert a SQL statement into the roll forward log.
The log_text function causes the SQL text given as first argument to be executed at roll forward time with the following arguments as parameters, bound from left to right to the parameter markers in the statement ('?'). There can be a maximum of 8 parameters but these can be arrays.
Parameters
text
VARCHAR SQL statement to be added in the transaction log.
arg1..arg8
Parameters to be passed to logged statement.
Examples
Example 24.210. Log a procedure call
Log a procedure call instead of its effects.
create procedure xx ()
{
log_text ('xx (?)', arg);
log_enable (0);
... action code
log_enable (1);
}