A varchar with the contents of the string output stream.
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.
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.