Oracle convert GIF BLOB to JPG BLOB
Posted on 2014-02-13
Oracle 11g release 18.104.22.168
Crystal reports 2011 version 22.214.171.1248 RTM
I have a product database that stores GIF images in a BLOB column. Crystal Report does not support GIF images. I can display JPG BLOB images from an oracle database in Crystal Reports without any problems. Using only oracle SQL or PL/SQL how do I convert a GIF BLOG to a JPG BLOB.
I have search the internet and believe that it can be done, but there is no clear example of how to do it.
Thank you for your help