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?