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
SELECT b INTO dest_lob
WHERE a = 1
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?
08-22-2006, 02:24 AM
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 ?
08-22-2006, 05:25 AM
I used this proc to insert data into the table before I tried appending.
CREATE OR REPLACE PROCEDURE Insertblob( BLOBPARAMETER BLOB) AS
INSERT INTO BLOBTABLE VALUES(1,BLOBPARAMETER);
I couldnt go ahead with your suggestion of using RAW while inserting as the front end sends data as a BLOB to the proc.