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.
I don't know for sure, but referring to the documentation, I would say that using the PROCESS method should be the key information here:
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE