Problem in retrieving blob from database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Problem in retrieving blob from database

  1. #1
    Join Date
    Oct 2002
    Posts
    109

    Problem in retrieving blob from database

    Hi All
    can any one help me ,How I can write a procedure to retrieve a blob from a table and write to the O.S file.
    by usng dbms+lob and utl_ pack file.
    can any one give me the source code?Will be very usefull for me.

    regards
    praveen

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

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

    Try these:

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

    9i Rel2 Upwards
    http://www.oracle-base.com/Articles/9i/ExportBlob9i.asp

    There is a known bug with the latter on Windows 2000. Not sure which patch contains the bug fix.

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  4. #4
    Join Date
    Oct 2002
    Posts
    109
    Hi Tim
    Thanks for your reply.
    I am new to oracle/Java.
    Can you help me out by giving me solution,that how I can perform the same job only by PL/SQL


    thanks and regards
    praveen


    Originally posted by TimHall
    Hi.

    Try these:

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

    9i Rel2 Upwards
    http://www.oracle-base.com/Articles/9i/ExportBlob9i.asp

    There is a known bug with the latter on Windows 2000. Not sure which patch contains the bug fix.

    Cheers

    Tim...

  5. #5
    Join Date
    Oct 2002
    Posts
    109
    Hi
    Thanks for your reply.
    I am new to oracle/Java.
    Can you help me out by giving me solution,that how I can perform the same job only by PL/SQL


    thanks and regards
    praveen






  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Upto 8i util_file can do only ascii files..i am not sure about 9i..if you are using 9i then probably you shoudl read the docs of 9i

    regards
    Hrishy

  7. #7
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Duplicate Thread ?

    http://dbasupport.com/forums/showthr...threadid=34454

    Well, but here u have more input. This should make the thread starter happy to get more info.

    Cheers.

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