The EXTENDED RESULT addition of the INTO clause can be used to provide an extended result of the current
main query in a result object. After EXTENDED RESULT you must specify an
object reference
variableoref of static type for the documented class CL_OSQL_EXTENDED_RESULT,
which points to an object of the class. The reference variable must be prefixed with the escape character @.
The following applies for use of EXTENDED RESULT:
The reference variable must not be initial and the object generation must be carried out before execution
of the Open SQL statement. Parameters specifying which values the extended result should include must be passed to the instance constructor of class CL_OSQL_EXTENDED_RESULT.
If possible, the result object is supplied with the requested values at first database access.
If a loop is opened with the statements SELECT
or WITH, the result object is supplied once at entry into the loop.
If the INTO clause after
FETCH is used for the results set
of a database cursor that is opened with OPEN
CURSOR, the result object is filled once in the first FETCH statement.
After the Open SQL statement is closed, the required values can be read using the instance methods of
the class. If the result object does not then contain any results, or no valid results, an exception of the class CX_OSQL_EXTENDED_RESULT is raised.