2 Replies Latest reply: Dec 9, 2010 3:17 PM by Mannamal-Oracle RSS

    ordsys.ordimage X pdf

    claudioaragao
      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