dbms_lob.append

[aspdba]

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..

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

[RBARAER]

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

[aspdba]

Hi RB,

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

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