Re: Converting long to blbo

something like example:

CREATE TABLE BLOB_TABLE (DATA BLOB);
v_content LONG RAW;
temp_blob BLOB;

      INSERT INTO BLOB_TABLE  (DATA)
        VALUES ( empty_blob() )
        RETURNING DATA
        INTO temp_blob;

      DBMS_LOB.WRITE (temp_blob, LENGTH(v_content), 1, v_content);

----------------------------------------------------------------------------

Channan Nussbaum wrote:

> Is there a simple way to convent long row to blob?
> In oracle 8i I use to_lob ib sql,
> but it did not work for me indise a stored procedure or trigger.
Received on Mon Jan 24 2000 - 10:44:51 CST