-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|