Sybernet / Supplied Procedures Reference Release 3.00 Oct 14, 2002

HTTP.HTTP_WRITE_CLOB

There are two procedures for writing writing LOB's (HTTP_WRITE_CLOB and HTTP_WRITE_BLOB). Since parameters to a stored procedure can be as large as 32,767 bytes, they have advantage over writing INSERT statements since the largest value allowed here is 4,000 bytes.

Syntax

Procedure HTTP_WRITE_CLOB
(
    LOB_LOCATOR                   CLOB
,   TEXT                          VARCHAR2
)   ;

Parameters

lob_locator

text

Example

The following example illustrates how to call http_write_clob:

DECLARE Locator CLOB;
BEGIN
    INSERT INTO HTTP_HELPTEXT values (MY_ROW_ID,sysdate,EMPTY_CLOB());
    SELECT DESCRIPTION
    INTO   Locator
    FROM   HTTP_HELPTEXT
    WHERE  ROW_ID = MY_ROW_ID;
    FOR    UPDATE;
    HTTP.HTTP_WRITE_CLOB(Locator,'Hello World');
END;

See Also