OCIIntervalMultiply()

Purpose

Multiplies an interval by an Oracle Number to produce an interval.

Syntax

sword OCIIntervalMultiply ( dvoid              *hndl, 
                            OCIError           *err, 
                            CONST OCIInterval  *inter,
                            OCINumber          *nfactor,
                            OCIInterval        *result );

Parameters

hndl (IN)

The OCI user session handle or the environment handle.

err (IN/OUT)

The OCI error handle. If there is an error, it is recorded in err and this function returns OCI_ERROR. Obtain diagnostic information by calling OCIErrorGet().

inter (IN)

Interval to be multiplied.

nfactor (IN)

Oracle Number to be multiplied.

result (OUT)

The resulting interval (inter * nfactor).

Returns

OCI_SUCCESS,

OCI_INVALID_HANDLE, if err is a null pointer,

OCI_ERROR, if any of the following are true:

• the resulting year would go above SB4MAXVAL
• the resulting year would go below SB4MINVAL

Related Functions

OCIIntervalDivide()