dbms_lob.append
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dbms_lob.append

  1. #1
    Join Date
    Aug 2002
    Posts
    115

    dbms_lob.append

    I have a blob column in one of my tables in which I woudl have some doc files.

    Now I need to append newer pages into the existing document in the database.

    Something like this..

    Code:
    CREATE OR REPLACE PROCEDURE updateblob( BLOBPARAMETER BLOB) AS
     dest_lob BLOB;
    BEGIN
    SELECT b INTO dest_lob
      FROM BLOBTABLE
      WHERE a = 1 
      FOR UPDATE;
    
    dbms_lob.append(dest_lob, BLOBPARAMETER);
    
    COMMIT;
    END;
    /
    Now it appears the new doc is appended (as I download the doc through an application into my local machine, the size of the doc has increased), but I dont see anything appended. I just see the contents of the original file, but the size of the file has increased.

    Can anyone point out where I might be going wrong?

    Thanks
    Sam

  2. #2
    Join Date
    May 2005
    Location
    France
    Posts
    34
    The problem may come from the way you filled BLOBPARAMETER before calling updateblob. Could you show us the call that does not seem to work ?

    Regards,

    rbaraer

  3. #3
    Join Date
    Aug 2002
    Posts
    115
    Hi RB,

    I used this proc to insert data into the table before I tried appending.

    Code:
    CREATE OR REPLACE PROCEDURE Insertblob( BLOBPARAMETER BLOB) AS
    BEGIN
    INSERT INTO BLOBTABLE VALUES(1,BLOBPARAMETER);
    END;
    /
    I couldnt go ahead with your suggestion of using RAW while inserting as the front end sends data as a BLOB to the proc.


    Thanks a lot...
    Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width