APEX

Can anyone please assist to me

Hi

There are two options. One to download the blob and one to display the blob.

The table containing the blob should have columns for storing mime_type, filename, last_updated and characterset

You can select the blob in your sql-statment by using dbms_lob.getlenght(blob column).

select id, dbms_lob.getlenght(blob column) image from table1;

Define the column in the report as Download BLOB. Set all the required attributes for the Download BLOB column.

install and review the file upload/download sample app for how to do this

Hi, You answered BLOB column Download option. But, I need to read the word files content(stored BLOB column) from Classic/Interactive Report. I don't want to download option. How to do? Thanks in Advance

Hi, You answered BLOB column Download option. But, I need to read the word files content(stored BLOB column) in Classic Report. I don't want to download option. How to do that? Please suggest me.

Insted of Download BLOB you pick Display Image. But I will not garantee that the browser will display a WORD-document. It will require some extra coding and setup. But for pdf and png which the browser supports it should work.

Based on your requirements it sounds like you should explore the tools available from United Codes, DOCX Templates | APEX Office Print (AOP)

Thanks for suggested me. But there is no display docs option and also not give detailed summary.

So, you're after extracting text from the DOCS or PDF document and display it directly on the page, right?

If that's the case, there is some functionality in the database, you might find useful: have a look into the CTX_DOC.POLICY_FILTER function. That function converts a BLOB containing PDF or Word contents to a CLOB containing the clear text or HTML representation. You might play with that a bit …

The API is not too developer-friendly (procedure with OUT parameters), so you might build yourself a bit of wrapper code to make the functionality easier to consume in your APEX app …

begin
  ctx_ddl.drop_policy(
    policy_name => 'filter_policy'
  );
end;
/
sho err

begin
  ctx_ddl.create_policy(
    policy_name => 'filter_policy',
    filter      => 'CTXSYS.AUTO_FILTER'
  );
end;
/
sho err

create or replace function filter_document(
  p_document in blob
) return clob
is
  l_data clob;
begin
  dbms_lob.createtemporary(
    lob_loc => l_data, 
    cache   => true, 
    dur     => dbms_lob.call
  );
  ctx_doc.policy_filter(
    policy_name => 'filter_policy',
    document    => p_document, 
    restab      => l_data
  );
  return l_data;
end;
/
sho err

With that in place, you can simply convert by calling your FILTER_DOCUMENT function …

I hope this helps

-Carsten