The default name of the file contains the PL/Vision log when writing to an operating system file. This can be -- and usually would be -- overridden with your own file name. It is only applicable if you are using PL/SQL Release 2.3 or above.

Name for rollback activity to not perform any rollback.

Name to indicate that a full rollback should occur.

Name to indicate that a rollback should occur to the default savepoint.

Name to indicate that a rollback should occur to the last savepoint recorded by PLVrb.

The default savepoint issued after a write to the log.

Turns on the logging activity; calls to put_line write information to the log (default).

Turns off the log mechanism.

Returns TRUE if the log is active.

Generic program to indicate the type of log (the repository to which information will be sent). The valid types are stored in the PLV package. If you choose PLV.file, you need to also provide a file name. You can also set the log type by calling one of the following procedures.

Requests that the information be sent to a PL/SQL table.

Requests that the information be sent to a database table.

Requests that the information be sent to an operating system file.

Requests that the information be sent to standard output.

Returns the current log target type. This type will be one of the repository constants defined in the PLV package.

Writes a line to the PLVlog repository. This version of put_line allows you to specify a full set of values for the log record.

This version of put_line keeps to an absolute minimum what you have to/want to provide to write a line to the log.

Reads a row from the PL/SQL table log, parses the contents, and returns the individual values in the separate OUT arguments of the parameter list.

Displays the contents of the current PLVlog log (either in the database table or in the PL/SQL table).

Empties the PL/SQL table associated with the PLVlog mechanism.

Returns the number of rows filled in the PLVlog PL/SQL table.

Determines which database table is to be used by PLVlog for logging. PLVlog relies on dynamic SQL, so you can at runtime specify the table and column names for this table.

Closes the operating system file if you have chosen a file for the log repository.

Transfers contents of PL/SQL log to the PLVlog database table.

Turns on the issuing of a ROLLBACK before an INSERT into the log.

Turns off the issuing of a ROLLBACK before an INSERT into the log.

Returns TRUE if PLVlog is issuing a ROLLBACK before an INSERT.

Sets the default savepoint used both for the ROLLBACK command before a log insert and the SAVEPOINT command after the log insert.

Sets the savepoint used both for the ROLLBACK command before a log insert to the last savepoint known to PLVrb.

Sets the default savepoint used both for the ROLLBACK command before a log insert to the PLVlog default savepoint.

Sets the name of the savepoint to be set after the call to put_line to write a line to the log.