Image not working in 11g

[szamrud]

Using pl_fpdf I'm able to put image in 10g environment on PDF reports, but when I try the same code in 11g I start getting the error message. look like image part of the code is not working in 11g. Any one has any idea or any solution.

procedure testImg is
img varchar2(2000);
begin
FPDF('P','cm','A4');
openpdf;
AddPage();
SetFont('Arial','B',16);
img := 'http://www.lcw-design.com/jpgAutoc/sigle1.jpg';
Image(img,1, 1, 10);
pl_fpdf.output ();
end testImg;

[Pilooz]

Hi,
Could you please send the error message you get ?

[szamrud]

Hi,
Here is the error, I'm getting.

Thanks,
Syed

[padarr]

I am also having this same issue with images.
I has an issue in the image parser.

Fri, 16 Oct 2015 19:09:20 GMT

Failed to execute target procedure ORA-20100: <B>PL_FPDF error: </B>image : ORA-20100: <B>PL_FPDF error: </B>p_parseImage : ORA-20100: <B>PL_FPDF error: </B>Not a PNG file: http://www.chemeketa.edu/global_files/images/gen/social/facebook1-trans.png
ORA-06512: at "BANINST1.PL_FPDF", line 1948
ORA-06512: at "BANINST1.PL_FPDF", line 3322
ORA-06512: at "BANINST1.RECOGNITION_TEST", line 20
ORA-06512: at line 33

I modified the png_signature and signature_len variables because I noticed tha it wasn't matching what is at the tops of PNG files, looks like it need two more CHR(26) and the char length increased from 8 to 10

png_signature constant varchar2(10)  := chr(137) || 'PNG' || chr(13) || chr(10) || chr(26) || chr(26) || chr(26) || chr(10);
signature_len integer := 10;    

Do you have any ideas why this is an issue in 11g ?

[szamrud]

I tried every option but it doesn't work for me. I'm using as_pdf3 open source to generate PDFs.

[padarr]

I'm trying the as_pdf3 but I keep getting an invalid path error when I put
one of the demos in the script?

I could get the pl_fpdf to at least work, just not with images.

[szamrud]

pl_fpdf working fine without image, But if you really need image on PDF than only option is as_pdf3. If you search for p_dir and replace the directory name to your oracle directory, hope it will work fine for you.

p_dir varchar2 := 'Oracle Directory'

[padarr]

Is it trying to save to the database?
What I need it to do is open up a pdf just like the Output() function in
pl_fpdf

[szamrud]

For your test you can store in the blob column, for browser you can use as_pdf3.output
CREATE TABLE "TEST_PDF"
( "PDF_FILE" BLOB );

begin
as_pdf3.init;
as_pdf3.write( 'jpg, gif and png images are supported.' );
insert into test_pdf
values (as_pdf3.get_pdf ());
end;

select *
from test_pdf

[padarr]

I do not see this procedure anywhere in the package. as_pdf3.output doesn't exist in what I downloaded from here https://github.com/mortenbra/alexandria-plsql-utils/tree/master/extras

Is there more that I need to install other than the first two pks and pkb files?

[szamrud]

Add this code to your as_pdf3 package spec and body.

procedure output (pb_file blob);

procedure output (pb_file blob) is

lb_file blob;
begin
lb_file := pb_file;
OWA_UTIL.mime_header('application/pdf', FALSE);
HTP.p('Content-Length: ' || DBMS_LOB.getlength(lb_file));
OWA_UTIL.http_header_close;
wpg_docload.download_file(lb_file);
end;

[szamrud]

For Browser...

procedure proc_run_report
is
lb_blob blob;
begin
as_pdf3.init;
as_pdf3.write( 'jpg, gif and png images are supported.' );
lb_blob := as_pdf3.get_pdf ();
as_pdf3.output (lb_blob);
end;

[padarr]

Thank you szamrud... You Rock Sir!