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);
}


See Also

log_enable