Reports JFIF image stored in a blob
612156Oct 16 2008 — edited Nov 20 2008Hi everyone,
I'm using forms & reports 10g release 1. I noticed that a image stored in a blob with a format of JFIF doesn't work well with in Reports. I get the rep-62203, cannot render error. When the datatype is longraw instead of blob, it works fine. But I can't use longraw, because built in in pl/sql doesn't allow to read the field passe 32K. So that's why we convert to Blob.
I made a few test: 1) I stored a simple jpg with Toad and It work fine with Reports. I stored with a form but of a format of GIF it works fine. But the JFIF just doesn't work reports. What's the problem?
How can this be solve?
I thought maybe saving the image prior calling the report into a file and then link it with report. That will be my last choice. I prefere not to got there.
Any idea?