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.
dest_id number := 1;
img ordsys.ordimage ;
ctx raw(32676) := null;
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;
when others then
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
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.