DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Problem in extracting a BLOB column into a file

  1. 02-21-2005, 07:32 AM #1
    raju_sbd
    raju_sbd is offline Junior Member
    Join Date
    Apr 2002
    Posts
    34

    Problem in extracting a BLOB column into a file

    Hi

    I have wriiten a PL/SQL block to extract a BLOB column into a file. I am doing this using DBMS_LOB.READ and UTL_FILE.PUT_RAW. However, the size of the retrieved BLOB file is not mathcing with the size of the uploaded BLOB file. The size of the retrieved file is generally more than the inserted file. Can somebody tell me where is it going wrong?
    VVS Raju
    8i DBA OCP
    Reply With Quote Reply With Quote
  2. 02-21-2005, 10:23 AM #2
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    How many bytes are more in the new file?

    Tamil
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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