Oracle APEX: How to extract text from inside a PDF or Word Doc

Показать описание

In this video we will show you how to quickly extract all the text from inside a pdf or word document and store the information inside a CLOB for quick retrieval.

Our video begins with a table containing a BLOB column with several pdf's and .doc's. We will start by creating a filter on the table to index the documents leveraging CTXSYS.CONTEXT and CTXSYS.AUTO_FILTER.

With the information inside a CLOB Oracle APEX can now easily display and process the text to users at a fraction of the time it would take to display or download the BLOB.

Sample Code leveraged in this video:

Related Videos of Interest:
How to print a CLOB inside a Dialog Window in Oracle APEX

How to enable Full Text Search on a BLOB

Oracle APEX: How to add an Image as BLOB to Existing Table/Form/Report

Рекомендации по теме

Комментарии

This was super helpful. I'm passing the text from the PDF to the Cohere API and asking questions about what's in the PDF and it works like a dream. Thank you!

jeeves

wonderful! I've been trying to convert a PDF/BLOB to CLOB in APEX for days!! Thank you!

organismisimbiotici

Is there a way that I can do all this, but instead of inserting resumes into the table before the time, uploading them from a page in the app where it gets saved into the table? If so, how do I do this?

LiandiObermeyer

at here in oracle g11, does not work. Just staying an ' - ' after sucess process, do you know why?

kauecastelani

Hi., Same like can we extract the image from a word/docx file.?

uselvan

Hi, I have done all steps and works really fine, but when I try to convert a large pdf (54 pages) it only give me a string like this SKM_C3320i23022111200 in the filtered_docs table. I'm wondering if there's any limit of size with this index ?

luisf.rodriguezgarcia

Hello, can we upload records from oracle apex to an MDB format file?

asifiqbal

Hi I am getting with CTX_DOC package, I am using 21.2 apex version and Database 12C

ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_doc.filter
ORA-20000: Oracle Text error:
DRG-11207: user filter command exited with status 127

deepakdakhore

Oracle APEX: How to extract text from inside a PDF or Word Doc

Oracle apex web application | How to export and import oracle apex application

Beginner's Guide to Oracle APEX

Deploying Application in Oracle APEX - Part 39

Packaging Data with your App Exports in Oracle APEX 21.2

Oracle APEX: How to extract text from inside a PDF or Word Doc

Fetching and Parsing Data from Other Source To Oracle Database Using API/Web service in Oracle Apex

Oracle APEX All-in-One Tutorial Series (2.5 HOURS!)

Oracle Apex: Quick and easy: Instantly Download Interactive Excel Reports with One Click.

Getting started with APEX on Oracle Cloud - QuickStart

Oracle APEX - Data Parsing Using - APEX_DATA_PARSER API

How to Connect Oracle Apex Tables to Python: Apex REST

Oracle Apex 23.1 Installation?

Oracle APEX Guide for 2023!

Oracle APEX 24.1 Product Tour

Oracle APEX: JQuery/Javascript Syntax to get and set items inside Dynamic Action 3 min.

Part 2: Displaying two submission tables in the same page in Oracle Apex (C23)

Creating RESTFul API in Oracle APEX 19.2

Geolocation - Finding Device Location In Oracle APEX

Oracle Apex 20.2 - Uninstall Oracle Apex Any Version

Get Data from Web Service Reference in Oracle APEX using REST

Get Started with Oracle APEX - The History of APEX

Getting Started with Free APEX Workspace

Get GEO Location and Show Map in Oracle Apex # xfactor Oracle Apex

Consume External API In Oracle APEX