Procedure jpg (p_id in images.no_image%type) Any idea what the problem might be? Our initial impression was that it might be a mime problem.ĬREATE OR REPLACE package body insitu.image_get Here's the package body for the procedure. I tried right-clicking the broken link and saving the image, in case it's just a display problem, but the image, while being the same size as the original, is corrupted. I know the image makes it into the database just fine, since a Perl script can download it again, and the image is the same as the original (confirmed through visual inspection and checksum). I've tried adapting the procedure to display jpg images stored in the lobs, but the result is a broken image link. O using svrmgrl connect as INTERNAL OR SYS - only these users, no one else can successfully install UTL_RAW O find the two files with 'raw' in their name (eg: ls *raw*) UTL_RAW might not be installed on your database. Htp.prn( utl_raw.cast_to_varchar2( l_raw ) ) spurious line feeds getting added to your make sure to change this for your type!ĭbms_lob.read( l_lob, l_amt, l_off, l_raw ) Some browsers really want the extension in the URL to be 'correct')

Just keep adding procedures that are named after the file type like. Now here is the package that can retrieve the pdf (or anything for that matter. L_bfile := bfilename( 'MY_FILES', 'aria.gif' ) Insert into demo values ( 1, empty_blob() ) The following code just created a demo table and loads an image into it - you already have the pdfs loaded so its not 100% relevant to your problemĬreate or replace directory my_files as '/export/home/tkyte/public_html' You would of course change the mime type and the name of the procedure from. Here is an example that loads a GIF into the datbase and displays it. Sure, if you have the images in a BLOB, its quite easy.

Create pdf file from vb6 string length