http_url
write to HTTP client or string output stream with URL escapes
http_url
(in val_expr any,
[in tag varchar],
[in stream any]);
Parameters
val_expr –
A value expression. May be any scalar expression. If
val_expr is an XML entity, a serialization of
the entity is written to the stream. This is not
the XML as a text string, but a serialization of the internal
representation of parsed XML data.
tag –
Optional. If present and is a string, the output will be enclosed
in tags named by the string content of tag.
If the expression evaluates to 0 or null, it will be ignored.
stream –
Optional parameter. If omitted or is 0 and the function is
executed within VSP context, the
val_expr will
be written to the HTTP client. If present and non-zero,
val_expr will be written to the specified stream.
If non-zero, the value must be a valid stream obtained
from function
string_output
Description
The http_url is used to write to an HTTP
client (when in a VSP context) or a specified string output stream.
http_url uses URL escapes for special
characters.
Errors
SQLState |
Error Code |
Error Text |
Description |
37000
|
HT006
|
http output function outside of http context
and no stream specified: %s
|
|
22023
|
SR066
|
Unsupported case in CONVERT (%s -> VARCHAR)
|
|
Examples
HTTP output
Output of various flavours of http. See
string_output
and
string_output_string
for examples how to use http to write to streams
other than the HTTP output.
http (' % <b>') ' <b>
http_value (' % <b>') % <b>
http_url (' % <b>') +%25+<b>
http_value (12, 'li') <li>12</li>