Name

string_output_string — produce a string out of a string output stream

Synopsis

string_output_string ( in string_out any );
 

Description

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.

Parameters

string_out

The string output stream

Return Values

A varchar with the contents of the string output stream.

Examples

Example 24.410. Convert string output stream into a string

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.