This discussion is archived
2 Replies Latest reply: Dec 9, 2010 1:17 PM by mannamal RSS

ordsys.ordimage X pdf

claudioaragao Newbie
Currently Being Moderated
Hi, I found this link http://www.oracle.com/technology/sample_code/products/intermedia/files/quickstart_guides/intermedia_qs_image.pdf
and I tried import a image , but doesn't work.
I have the message
ORA-06508: PL/SQL: could not find program unit being called


this is the code.
declare
dest_id number := 1;
filename varchar2(100):='logo.png';
img ordsys.ordimage ;
ctx raw(32676) := null;
begin
delete
from image_table
where id = dest_id;
insert into image_table (id, image)
values (dest_id, ordsys.ordimage.init())
returning image into img;
img.IMPORTFROM(ctx, 'file', 'BACKUP', filename); --this is the line that error happen
update image_table set image=img where id=dest_id;
commit;
exception
when others then
raise_application_error(-20200,' '||sqlerrm);
end;


I´m using oracle 10g 10.2.0.3.0 and I can see the ordsys user and all objects


The question is...I need print a image into a pdf and the package that I´m using works the image with oracleintermedia.. so I´m trying to see if this sample works

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points