Name
blob_to_string_output — Convert a blob to string session
Synopsis
varchar blob_to_string_output ( |
in blob any ) ; |
Description
Although primarily used for converting blobs ( long varbinary ,
long varchar ) to string output object , blob_to_string_output
may also be used to convert
from wide string , persistent XML (XPER) and string_output streams .
Parameters
blob
blob handle (long varbinary or long varchar), string_output or XPER (persistent XML)
Return types
string output object contents of
blob
.
Errors
Table24.7.Errors signalled by
SQLState | Error Code | Error Text | Description |
---|---|---|---|
22023 | SR068 | XML tree cannot be used as argument of blob_to_string_output | |
22023 | SR070 | blob_to_string_output requires a blob or string argument | |
22023 | SR071 | Blob argument to blob_to_string_output must be a non-interactive blob |
Examples
Example24.29.Various conversions
SQL> use Demo; Done. -- 20 msec. SQL> select string_output_string (blob_to_string_output ("Description")) from "Categories"; callret VARCHAR _______________________________________________________________________________ Soft drinks, coffees, teas, beers, and ales Sweet and savory sauces, relishes, spreads, and seasonings Desserts, candies, and sweet breads Cheeses Breads, crackers, pasta, and cereal Prepared meats Dried fruit and bean curd Seaweed and fish 8 Rows. -- 37 msec. SQL>