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

Table 24.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

Example 24.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>


See Also

blob_to_string