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. |