Sybernet / Supplied Procedures Reference Release 3.00 Oct 14, 2002

HTTP.HTTP_SELECT_BLOB

You cannot pass a LOB directly to WRITE(), but you can retrieve a LOB in pieces and pass them. See Example: Display the LOB Data Using PL/SQL from the write up on Internal Persistent LOBs.

You can pass a "lob locator" to HTTP_SELECT_CLOB() or HTTP_SELECT_BLOB(). Binary LOB's need to be sent to Sybernet as Hexadecimal strings which are translated to Ascii using the <ASCEncode> and </ASCEncode> tags. HTTP_SELECT_BLOB() does this automatically for you.

Syntax

Procedure HTTP_SELECT_BLOB
(
    LOB_LOCATOR                   BLOB
)   ;

Parameters

lob_locator

Example

The following example illustrates how to retrieve a BLOB and write that to Sybernet.

DECLARE Locator BLOB;
BEGIN
    SELECT PICTURE
    INTO   Locator
    FROM   HTTP_PICTURES
    WHERE  ID = 'bug';
    HTTP.HTTP_SELECT_BLOB(Locator);
END;

See Also