Which method of class CL_SQL_RESULT_SET retrieves the result set of the native SQL call?

The method that retrieves the result set of a native SQL call within class CL_SQL_RESULT_SET is NEXT_PACKAGE. This method is specifically designed to fetch the rows of data that result from executing SQL commands. When a SQL statement is executed, the results are stored in a result set object. The NEXT_PACKAGE method allows you to iterate through the results efficiently, retrieving one or more packages of rows at a time.

Understanding how NEXT_PACKAGE works is crucial in scenarios involving large data sets, as it helps manage memory consumption by not loading the entire result set into memory at once but processing it in manageable chunks.

The other methods mentioned serve different purposes: EXECUTE_QUERY is used for executing a SQL statement, while SET_PARAM_TABLE and SET_PARAM are for setting input parameters for the SQL execution, rather than retrieving results. This distinction clarifies why NEXT_PACKAGE is specifically the method associated with retrieving the actual result set.