GetList Transact-SQL Stored Procedure

This Transact-SQL stored procedure fetches a list of records based on search criteria.

Parameter Name

Type

Description

p_from_str

VARCHAR2

The additional tables with which a join operation is performed.  This forms the FROM clause in the SQL query.

p_search_str

VARCHAR2

The search criteria forming the WHERE clause of the SQL query.

p_sort_str

VARCHAR2

The sorting criteria forming the ORDER BY clause of the SQL query.

p_page_number

INTEGER

The page within the result set whose data is to be returned.

p_batch_size

INTEGER

The total number of records to be displayed in a page (table grid).

p_total_size

INTEGER

Output

The total number of records in the result set of the SQL query.

p_list

Cursor

Output

A cursor containing the result set of the SQL query.

See Also

Transact-SQL Stored Procedures for Microsoft SQL Server