3 Replies Latest reply: Nov 25, 2011 2:03 AM by 902007 RSS

    Displaying TIFF images in Oracle Forms 6i

    902007
      Hello, friends!
      I am working in Oracle Forms 6.0.8 (that ancient tool) and encounter a problem with displaying TIFF images.
      I have a number of scanned images and some of them are displayed and some are not. I've tried both extracting them from the database or from the file system (using READ_IMAGE_FILE). Sometimes I am getting just blank field in my image item and sometimes (after using READ_IMAGE_FILE) I get the error FRM-47100 (cannot read image file). Of course I've checked that all the files are displayed using standard tools for displaying TIFFs.
      Basically the question is what kind of TIFF is considered valid and readable by Oracle Forms.
      Analyzing TIFF tags actually gave me nothing: I have a pair of files with tags different only in image width/length and a number of rows/strip (but even those values are close), and one of the file is displayed correctly while the other is not. The thing I noticed is that invalid files are using compression type of CCITT Group 4.
      Possibly Oracle Forms follows TIFF specification only to certain extent and does not support all the extensions, while sometimes the problems are not visible to user.
      As a result of my work I need some automatic tool that converts undisplayable TIFF files to displayable ones but firstly I am to determine where the problem is. And it would be very good to have a prooflink that approves my decision.

      Looking forward to any help! Thanks in advance.
        • 1. Re: Displaying TIFF images in Oracle Forms 6i
          InoL
          I'm not sure about TIFF, but I know that Forms does not support Exif meta data in JPG files. Does TIFF support Exif tags at all and if so, do your files have these?
          • 2. Re: Displaying TIFF images in Oracle Forms 6i
            user12206082
            looking at oracle support:

            READ_IMAGE_FILE Fails With FRM-47100 For JPG's Stored In Exif Type Format. [ID 402773.1]

            just what the other posting indicated, it can not read tiff contain EXIF information


            removing Exif information.

            InfraView has functionality which will convert all images in a certain directory in batch.

            [http://www.irfanview.com/]
            • 3. Re: Displaying TIFF images in Oracle Forms 6i
              902007
              Thanks to everybody, but I'm afraid my files don't contain any EXIF tags (although TIFF seems to support them). The file doesn't contain any tags with IDs greater than 0x7FFF but only core TIFF tags (with IDs of lower numbers). Moreover I have a file with exactly the same set of tags (but the values are a bit different) which is displayed properly.
              I've shared the issued file (nondisplayable) on the following link: [https://rapidshare.com/files/3137807470/2.tif]
              If anyone could tell me why isn't it displayed in Forms I would be very grateful.