Report Builder: SRW package

1 SRW. BREAK: the execution of the Report is interrupted temporarily, and all column values and parameter values are displayed. After the report is displayed, the execution of the report can be resumed from the breakpoint.

Syntax: SRW. BREAK;

2 SRW. DO_ SQL: used to execute the specified SQL statement in Report Builder.

Syntax: SRW. DO_ SQL (SQL STATEMENT CHAR );

3 SRW. MESSAGE: used to display a MESSAGE, which consists of the Information Code and text specified by the user.

Syntax: SRW. MESSAGE (MSG required mumber number, MSG required test char );

 

4 SRW. REFERENCE: Used to add a specified object and pass it to the relevant tables of PL/SQL blocks.

Syntax: SRW. REFERENCE (: object char | DATE | NUMBER );

5 SRW. RUN_REPORT: Used in Command Line Mode

Syntax: SRW. RUN_REPORT (COMMAND using line char );

6 SRW. SET ˍ ATTR: used to SET the font, size, color, and other format attributes of the report object.

Syntax: SRW. ATTR. MASK: = SRW. ATTR_ATTR [+ SRW. ATTR_ATTR…];

7 SRW. ATTR_ATTR: = VALUE;

SRW. SET_ATTR (0 | SRW. REPORT_ID, SRW. ATTR );

8 SRW. SET_FIELD_CHAR: used to set the values of struct fields.

Syntax: SRW. SET_FIELD_CHAR (OBJECT upload ID, text char );

9 SRW. SET_FIELD_DATE: used to set the value of the date type field.

Syntax: SRW. SET_FIELD _ DATE (OBJECT upload ID, DATE );

10 SRW. SET_FIELD_NUM: used to set the value of a numeric field.

Syntax: SRW. SET_FIELD_NUM (OBJECT upload ID, number num );

11 SRW. SET_MAXROW: used to set the maximum number of records retrieved from a specified query.

Syntax: SRW. SET_MAXROW (QUERY partition NAME, maxnum pls specify INTEGER );

11 SRW. TRACE_ADD tracing OPTION: used to specify a new tracing OPTION after the TRACE tag is started with SRW. TRACE tracing START.

Syntax: SRW. TRACE_ADD partition OPTION (SRW. TRACEOPTS );

12 SRW. TRACE_REM deleted OPTION: Used to delete existing trace options.

Syntax: SRW. TRACE_REM sort OPTION (SRW. TRACEOPTS );

13 SRW. TRACE_END: Used to terminate recording of trace information to a file during report execution.

Syntax: SRW. TRACE _ END ()

14 SRW. TRACE_START: used to record trace information to a file during report execution.

Syntax: SRW. TRACEOPTS. MASK: = SRW. TRACE_OPTS [+ SRW. TRACE_OPTS…]

SRW. TRACE_START (FILENAME, {SRW, TRACE_REPLACE | SRW. TRACE_APPEND}, SRW. TRACEOPTS );

15 SRW. USER_EXIT: used to call the user exit specified by the user exit using STRING parameter.

Syntax: SRW. USER_EXIT (user exit using string char );

16 SRW. USER_EXIT20: similar to SRW. USER_EXIT, the difference is that five parameters instead of two parameters are included when the user exit is called.

Syntax: SRW. USER_EXIT (user exit using string char );

17 SRW. GET_PAGE_NUM: returns the current page number;

Syntax: SRW. GET_PAGE_NUM (page num)

 

For details, see "srw .pdf ".