Sybernet / Supplied Procedures Reference Release 3.00 Oct 14, 2002

HTTP.HTTP_SELECT_CLOB

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_CLOB
(
    LOB_LOCATOR                   CLOB
)   ;

Parameters

lob_locator

Returns

Example

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

DECLARE Locator CLOB;
BEGIN
    SELECT DESCRIPTION
    INTO   Locator
    FROM   HTTP_HELPTEXT
    WHERE  ROW_ID = MY_ROW_ID;
    HTTP.HTTP_SELECT_CLOB(Locator);
END;

See Also