Sybernet / Supplied Procedures Reference Release 3.00 Oct 14, 2002

HTTP.HTTP_WRITE_BLOB

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_BLOB
(
    LOB_LOCATOR                   BLOB
,   TEXT                          VARCHAR2
)   ;

Parameters

lob_locator

text

Example

The following example illustrates how to call http_write_blob:

DECLARE Locator BLOB;
BEGIN
    INSERT INTO HTTP_PICTURES values (MY_ROW_ID,sysdate,EMPTY_BLOB());
    SELECT DESCRIPTION
    INTO   Locator
    FROM   HTTP_PICTURES
    WHERE  ROW_ID = MY_ROW_ID;
    FOR    UPDATE;
    HTTP.HTTP_WRITE_BLOB(Locator,'313131313131');
END;

See Also