SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

display blob field on pdf with pl_fpdf

911411Jan 17 2012 — edited Jan 25 2012

Hi All,

I wish I could use some method to output PDF from the PL/SQL. I already have a document (image stored as BLOB). Now, I need to output this image in PDF. I know doing this outside database is easy and advisable.
When I use pl_fpdf with image from url it work fine but when i want to display the image from blob I have this error:

ORA-20100: PL_FPDF error: image : ORA-20100: PL_FPDF error: p_parseImage : ORA-20100: PL_FPDF error: pl_fpdf.getImageFromUrl :ORA-31001: Invalid resource handle or path name "https://intranet.momentumtechnologies.ca/pls/prod_intranet/MOM_HTMLDB.PRC_AFFCH_IMAGE_DIVSN?P_IDE_DIVSN=0", image :https://intranet.momentumtechnologies.ca/pls/prod_intranet/MOM_HTMLDB.PRC_AFFCH_IMAGE_DIVSN?P_IDE_DIVSN=0
+ Erreur Echec impression+

I run this using Oracle APEX

Database: Oracle 9.2 running in Windows server.

Thanks in advance.
hakim

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 22 2012

Added on Jan 17 2012

5 comments

1,253 views