Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to store PDF file in BLOB column without using indirect datastore

12324-OracleJun 27 2007 — edited Jun 28 2007

Hi ,

I want to store a pdf file in a BLOB column.
But , it should be a direct store. I cannot usre indirect datastore.

BLOB column doesn't support indirect datastore. I get the following error.

ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10581: indirect datastores cannot be used with long or lob text columns
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 365

can anyone give me any clue onhow to manage this issue?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 26 2007

Added on Jun 27 2007

#database-key-features, #text

6 comments

18,663 views