Expand All Collapse All

sprpt_UserActivity Stored Procedure

  • Last Changed Version - 16.2.0.342
  • Last Changed Reason - Updated for fixing dynamic where clause lengths.

Parameter Definitions

Column Parameter Direction Data Type (Size) Description
@WhereClause INPUT nvarchar (4000)

Filters the data set based on the selected filtering options.
@OrderClause INPUT nvarchar (2048)

Orders the data set based on the selected ordering options.
Column Parameter Direction Data Type (Size) Description
i_WhereClause INPUT varchar2

Filters the data set based on the selected filtering options.
i_OrderClause INPUT varchar2

Orders the data set based on the selected ordering options.
o_prc OUTPUT sys_refcursor