2 Replies Latest reply: Dec 9, 2010 3:17 PM by mannamal 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
        • 1. Re: ordsys.ordimage X pdf
          mannamal
          I just tried this exact same script and this works.

          So I am not sure what the problem is in your case. Did you see the method importFrom under ORDImage?

          Melli
          • 2. Re: ordsys.ordimage X pdf
            mannamal
            Could you try running $ORACLE_HOME/ord/im/admin/imchk.sql?

            After that could you also try:
            select status from dba_registry where comp_id = 'ORDIM';

            Both of these need privileges to access them (imchk.sql and the table dba_registry).

            These will tell you whether the Multimedia/interMedia installation/upgrade is valid.

            Melli