Styjun

Function argument returning void or non-void type

What are Antecedent & Consequent Phrases in Music?

WAS IT A CAT I SAW? Do Some Detective Work & Catch The Imposters

SFDX: where can set Field-level security and accessibility?

Can my floppy disk still work without a shutter spring?

便利な工具 what does な means

Why does Bran want to find Drogon?

Is there a context where the expression `a.b::c` makes sense?

What could a self-sustaining lunar colony slowly lose that would ultimately prove fatal?

Is my plasma cannon concept viable?

Is it legal to have an abortion in another state or abroad?

I know that there is a preselected candidate for a position to be filled at my department. What should I do?

How do I superimpose two math symbols?

Where is Jon going?

Job Market: should one hide their (young) age?

Why did Jon Snow do this immoral act if he is so honorable?

Why do we need to chain the blocks (creating blockchain) in a permissioned blockchain?

Find this cartoon

Why are GND pads often only connected by four traces?

Should there be an "a" before "ten years imprisonment"?

Making a electromagnet

Did this character show any indication of wanting to rule before S8E6?

Why are Stein manifolds/spaces the analog of affine varieties/schemes in algebraic geometry?

Why did other houses not demand this?

Display extracted text from Oracle Full Text Index on MS Word/PDF

Oracle Unique IndexesOracle Data Type for text file?How to rename a primary key in Oracle such that it can be reusedManaging BLOBS in Oracle 11gAbout restrictive record creation in a child table. (Oracle Forms Builder)Why oracle CHOOSE INDEX RANGE SCAN over FAST FULL INDEX SCANOracle alter index to allow index on null valuesI keep getting errors in my procedure that help add new course and i have put requirements in descriptionIs Oracle alter table drop constraint drop index syntactically valid?Oracle Full Text Index Order by clause gives error

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

Need to create full text index on MS word and pdf files and extract text that matches some criteria.

I tried following steps on https://oracle-base.com/articles/9i/full-text-indexing-using-oracle-text-9i to import files and create index on the files but I need to show actual text that was matched from the select statement. Anyway I can do this?

 CREATE TABLE my_docs (
 id NUMBER(10) NOT NULL,
 name VARCHAR2(200) NOT NULL,
 doc BLOB NOT NULL
 );

 ALTER TABLE my_docs ADD (
 CONSTRAINT my_docs_pk PRIMARY KEY (id)
 );

 CREATE SEQUENCE my_docs_seq;

 CREATE OR REPLACE DIRECTORY documents AS 'C:work';

 CREATE OR REPLACE PROCEDURE load_file_to_my_docs (p_file_name IN 
 my_docs.name%TYPE) AS
 v_bfile BFILE;
 v_blob BLOB;
 BEGIN
 INSERT INTO my_docs (id, name, doc)
 VALUES (my_docs_seq.NEXTVAL, p_file_name, empty_blob())
 RETURN doc INTO v_blob;

 v_bfile := BFILENAME('DOCUMENTS', p_file_name);
 Dbms_Lob.Fileopen(v_bfile, Dbms_Lob.File_Readonly);
 Dbms_Lob.Loadfromfile(v_blob, v_bfile, Dbms_Lob.Getlength(v_bfile));
 Dbms_Lob.Fileclose(v_bfile);

 COMMIT;
 END;
 /

 EXEC load_file_to_my_docs('FullTextIndexingUsingOracleText9i.doc');

oracle

share|improve this question

asked Mar 24 at 0:49

ScottScott

11

add a comment | 

0

Need to create full text index on MS word and pdf files and extract text that matches some criteria.

I tried following steps on https://oracle-base.com/articles/9i/full-text-indexing-using-oracle-text-9i to import files and create index on the files but I need to show actual text that was matched from the select statement. Anyway I can do this?

 CREATE TABLE my_docs (
 id NUMBER(10) NOT NULL,
 name VARCHAR2(200) NOT NULL,
 doc BLOB NOT NULL
 );

 ALTER TABLE my_docs ADD (
 CONSTRAINT my_docs_pk PRIMARY KEY (id)
 );

 CREATE SEQUENCE my_docs_seq;

 CREATE OR REPLACE DIRECTORY documents AS 'C:work';

 CREATE OR REPLACE PROCEDURE load_file_to_my_docs (p_file_name IN 
 my_docs.name%TYPE) AS
 v_bfile BFILE;
 v_blob BLOB;
 BEGIN
 INSERT INTO my_docs (id, name, doc)
 VALUES (my_docs_seq.NEXTVAL, p_file_name, empty_blob())
 RETURN doc INTO v_blob;

 v_bfile := BFILENAME('DOCUMENTS', p_file_name);
 Dbms_Lob.Fileopen(v_bfile, Dbms_Lob.File_Readonly);
 Dbms_Lob.Loadfromfile(v_blob, v_bfile, Dbms_Lob.Getlength(v_bfile));
 Dbms_Lob.Fileclose(v_bfile);

 COMMIT;
 END;
 /

 EXEC load_file_to_my_docs('FullTextIndexingUsingOracleText9i.doc');

oracle

share|improve this question

asked Mar 24 at 0:49

ScottScott

11

add a comment | 

Need to create full text index on MS word and pdf files and extract text that matches some criteria.

I tried following steps on https://oracle-base.com/articles/9i/full-text-indexing-using-oracle-text-9i to import files and create index on the files but I need to show actual text that was matched from the select statement. Anyway I can do this?

 CREATE TABLE my_docs (
 id NUMBER(10) NOT NULL,
 name VARCHAR2(200) NOT NULL,
 doc BLOB NOT NULL
 );

 ALTER TABLE my_docs ADD (
 CONSTRAINT my_docs_pk PRIMARY KEY (id)
 );

 CREATE SEQUENCE my_docs_seq;

 CREATE OR REPLACE DIRECTORY documents AS 'C:work';

 CREATE OR REPLACE PROCEDURE load_file_to_my_docs (p_file_name IN 
 my_docs.name%TYPE) AS
 v_bfile BFILE;
 v_blob BLOB;
 BEGIN
 INSERT INTO my_docs (id, name, doc)
 VALUES (my_docs_seq.NEXTVAL, p_file_name, empty_blob())
 RETURN doc INTO v_blob;

 v_bfile := BFILENAME('DOCUMENTS', p_file_name);
 Dbms_Lob.Fileopen(v_bfile, Dbms_Lob.File_Readonly);
 Dbms_Lob.Loadfromfile(v_blob, v_bfile, Dbms_Lob.Getlength(v_bfile));
 Dbms_Lob.Fileclose(v_bfile);

 COMMIT;
 END;
 /

 EXEC load_file_to_my_docs('FullTextIndexingUsingOracleText9i.doc');

oracle

share|improve this question

asked Mar 24 at 0:49

ScottScott

11

 CREATE TABLE my_docs (
 id NUMBER(10) NOT NULL,
 name VARCHAR2(200) NOT NULL,
 doc BLOB NOT NULL
 );

 ALTER TABLE my_docs ADD (
 CONSTRAINT my_docs_pk PRIMARY KEY (id)
 );

 CREATE SEQUENCE my_docs_seq;

 CREATE OR REPLACE DIRECTORY documents AS 'C:work';

 CREATE OR REPLACE PROCEDURE load_file_to_my_docs (p_file_name IN 
 my_docs.name%TYPE) AS
 v_bfile BFILE;
 v_blob BLOB;
 BEGIN
 INSERT INTO my_docs (id, name, doc)
 VALUES (my_docs_seq.NEXTVAL, p_file_name, empty_blob())
 RETURN doc INTO v_blob;

 v_bfile := BFILENAME('DOCUMENTS', p_file_name);
 Dbms_Lob.Fileopen(v_bfile, Dbms_Lob.File_Readonly);
 Dbms_Lob.Loadfromfile(v_blob, v_bfile, Dbms_Lob.Getlength(v_bfile));
 Dbms_Lob.Fileclose(v_bfile);

 COMMIT;
 END;
 /

 EXEC load_file_to_my_docs('FullTextIndexingUsingOracleText9i.doc');

share|improve this question

asked Mar 24 at 0:49

ScottScott

11

share|improve this question

asked Mar 24 at 0:49

ScottScott

11

asked Mar 24 at 0:49

ScottScott

11

asked Mar 24 at 0:49

ScottScott

11