This function is used to produce a string from contents of a string output stream. See string_output for more information about string output streams.
A varchar with the contents of the string output stream.
Create a string output, write 'foo' and ' bar' into it, convert to string and produce a result.
SQL> create procedure ex_string_output_string () { declare s_out any; s_out := string_output(); declare s varchar; result_names (s); http('foo', s_out); http(' bar', s_out); s := string_output_string (s_out); result (s); } ; SQL> ex_string_output_string (); s VARCHAR NOT NULL _______________________________________________________________________________ foo bar 1 Rows. -- 5 msec.