Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Customize Your Partitioning Scheme › Customizable SQL Statement Procedures

Customizable SQL Statement Procedures

These customizable procedures are invoked when executing SQL statements during a purge operation. You can use them, for example, to provide additional auditing capabilities to your partitioning and purging scheme. You customize these procedures in the package body of wgn_partition_cust. The prototypes are listed below.

• This procedure is invoked immediately before executing each SQL statement.

  PROCEDURE wgn_on_stmt_start
  (stmt IN VARCHAR2);
  

• This procedure is invoked immediately after successfully executing each SQL statement.

  PROCEDURE wgn_on_stmt_end
  (stmt IN VARCHAR2);
  

• This procedure is invoked immediately after failing to execute any SQL statement. It is passed the actual statement plus the associated error.

  PROCEDURE wgn_on_stmt_fail
  (stmt IN VARCHAR2,
  sql_error IN VARCHAR2);