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