# 22. Virtuoso Functions Guide - string_output_string

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
ascii
atoi
blob_to_string
blob_to_string_outpu...
chr
initcap
isblob
isstring
lcase
left
length
locate
ltrim
make_string
regexp_instr
regexp_like
regexp_match
regexp_parse
regexp_replace
regexp_substr
repeat
replace
right
rtrim
search_excerpt
serialize
space
split_and_decode
sprintf
strcasestr
strchr
string_output
string_output_flush
string_output_gz_com...
string_output_string
string_to_file
strrchr
strstr
subseq
substring
tmp_file_name
trim
ucase
upper
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## string_output_string

produce a string out of a string output stream
string_output_string (in string_out any);
Parameters
string_out – The string output stream
Return Values

A varchar with the contents of the string output stream.

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.

Examples
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.

See Also

string_output , http, http_value, http_rewrite.