Dear Community!
I would like to pass a blob-Image into a procedure from the reporting tool PL/PDF.
The blob is selected with
select imgblob into v_image from tmp_tpet_imgsloadup where imgid = 100 for update;
... and the further usage with the PL/PDF-tool looks like this:
plpdf.printimagecell(
p_w => 100,
p_h => 100,
p_name => 'test',
p_data => v_image,
p_type => 'PNG'
);
Then the procedure just keeps running for a very long time, and after about 5 or 10 minutes I get an error message, saying
ORA-06512: in "SYS.DBMS_LOB", Zeile 1056
...
01403. 00000 - "no data found"
*Cause: No data was found from the objects.
*Action: There was no data from the objects which may be due to end of fetch.
I dont think the error happens in the plpdf.printimagecell-procedure, but I suspect there is some problem with fetching the blob file.
I have read throu the DBMS_LOB documentation, but had no answer.
I had also tried with another attempt:
dbms_lob.createtemporary(v_img1, true, dbms_lob.session);
dbms_lob.copy(dest_lob => v_img1, src_lob => v_image, amount => dbms_lob.getlength(v_image));
but with the same result.
I hope anyone can help me here with this. Maybe someone here has come accross the same problem. If you need mor information, please let me konw.
Thanks a buch ahead and best regards,
Tobi