image from db to local drive

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cmuraz
    New Member
    • Nov 2008
    • 13

    image from db to local drive

    helo all,

    i need to get image files from oracle database to local drive say "c:\photos"

    i dont know the procedure to do it. i want to know how to do it and in which format i ll get in the local drive

    pls help me regarding this.

    thanks and regards

    muthu
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    How you have stored the data in the database ? It is the file or the file path only.

    Comment

    • cmuraz
      New Member
      • Nov 2008
      • 13

      #3
      i ve stored the image in the column. not the external file.

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        You need to use some frontend tool for that. You need to convert the binary stream to recreate the file.

        Comment

        • amitpatel66
          Recognized Expert Top Contributor
          • Mar 2007
          • 2358

          #5
          Can you post the table structure in which you have stored the image file?

          Comment

          • cmuraz
            New Member
            • Nov 2008
            • 13

            #6
            ADM_NO CHAR(7) [primary key]
            PHOTO LONG RAW

            this is the structure of the table

            Comment

            • cmuraz
              New Member
              • Nov 2008
              • 13

              #7
              thanks mr.debasisdas
              can i know whats the front end tool to extract it?
              im using forms 6i in which i can view it. but i cant save to a client system folder. or is there any method in forms 6i to save to a local system?

              Comment

              Working...