Export Transact-SQL Stored Procedure

This Transact-SQL stored procedure exports records from the table based on search criteria.

Parameter Name

Type

Description

p_title_str

VARCHAR2

The column headings to be placed in the file’s header row..

p_select_str

VARCHAR2

The field names to be returned.  This forms the SELECT clause in the SQL query.

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_clob

CLOB

Output

The contents of the file being exported.

p_num_exported

NUMBER

Output

The number of records exported.

See Also

Transact-SQL Stored Procedures for Microsoft SQL Server