Simple LOB copy example?

From: Sandijs Jercums <sandijs_at_it.lv>
Date: Thu, 6 Jan 2000 12:37:51 GMT
Message-ID: <38748C9F.BCC82E92@it.lv>

   PROCEDURE submit_part

      (v_content IN CLOB, v_name IN VARCHAR2) IS

      temp_clob CLOB;
     V_MC_ID NUMBER;

   BEGIN

      SELECT MC_SEQ.NEXTVAL
        INTO V_MC_ID
        FROM DUAL;

      INSERT INTO M_C (ID, NAME, CPDATA_C)
      VALUES (V_MC_ID, v_name, EMPTY_CLOB());

      SELECT CPDATA_C  -- here I get an error: ORA-01403: no data found
        INTO temp_clob
        FROM M_C
      WHERE ID = V_MC_ID;

      DBMS_LOB.COPY(temp_clob, v_content,

DBMS_LOB.GETLENGTH(v_content));

   END submit_part;

CPDATA_C column of M_C table is CLOB. I just want to copy v_content into CPDATA_C column. Where am I wrong?

Tnx,
Sandijs Received on Thu Jan 06 2000 - 06:37:51 CST