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

Thread: BLOB back to file

  1. #1
    Join Date
    Jan 2002
    Posts
    2

    Cool

    Hi there,

    I am interested in learning more about Oracle's fuctionality of converting image date internally. To this purpose, I want to toy around with BLOB (in my case image) data. I have found plenty of exapmles how to load data from a file to a BLOB.
    I am interested to find out about the reverse way.

    >> How do I get the data stored in a BLOB back to a file? <<

    To keep it simple, I would like to do this in PL/SQL.

    Thanks in advance for any advice.

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    I know exactly what you mean. When I started using interMedia all routines for export were stubs with no support. I ended up writing some stored java code to do it:

    http://www.oracle-base.com/Articles/...rtOfImages.asp

    It's not directly related to your issue but since the interMedia datatype ORDIMAGE actually stores the data in a BLOB the code shouldn't need that much adjustment for it to work for you. At least it will point you in the right direction.

    Good luck.

    PS. Later versions of interMedia do support export of data but they require directory objects rather than explicit paths.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    I've just knocked up a cutdown of that other article more suited to your problem.

    This should get you started:

    http://www.oracle-base.com/Articles/8i/ExportBlob.asp

    [Edited by TimHall on 01-23-2002 at 09:42 AM]
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  4. #4
    Join Date
    Jan 2002
    Posts
    2

    Thumbs up

    Tim,

    I just followed the steps on the 2nd web page you suggested and it seems to work. Thanks a lot for the fast and helpful reply!

    Ingo

  5. #5
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Glad to be of service
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width