If you have invoked a database, you have the necessary privileges
to use the START_SEGMENTED_STRING statement.
Starts a stream of segmented string segments within a record
stream. Retrieving records with segmented string fields requires
a kind of "segment stream" within a record stream. This second
stream is normally established by nesting a special segmented
string FOR loop inside another FOR loop. However, in certain
cases, you cannot or may not want to use FOR loops (as in
Callable RDO programs).
The START_SEGMENTED_STRING statement is similar to the START_
STREAM statement: it starts a "stream" of string segments. You
do not use a FETCH statement to retrieve each segment. The PRINT
or GET statement retrieves the segment and advances the pointer
to the next segment. At the end of the stream, Oracle Rdb returns an
end-of-stream message, SEGSTR_EOF.
To end the stream, use the END_SEGMENTED_STREAM statement.