Sybernet / Supplied Procedures Reference
Release 3.00
Oct 14, 2002

HTTP.SP_AUDIT

This procedure is used to audit the initial invocation of a stored procedure. It will create a row in the HTTP.HTTP_AUDITFILE containing the name of your procedure, the date and time the row was created, the user who invoked it, and their IP address.

Syntax

Procedure SP_AUDIT
(
    PROCNAME                      VARCHAR2
,   UDEF1                         VARCHAR2
,   UDEF2                         VARCHAR2
,   UDEF3                         VARCHAR2
,   UDEF4                         VARCHAR2
,   UDEF5                         VARCHAR2
)   ;

Parameters

Parameter	Description
procname	The fully qualified name of your procedure.
udef1	optional audit text.
udef2	optional audit text.
udef3	optional audit text.
udef4	optional audit text.
udef5	optional audit text.

Example

The following example illustrates how to call sp_audit:

http.sp_audit('HTTP.SP_HTML_ISQL');