Q:Problem with BLOB and Context Cartridge

From: Samer Habib <sha_at_mms-dresden.telekom.de>
Date: Thu, 22 Jul 1999 14:23:21 +0200
Message-ID: <37970D39.D35B890D_at_mms-dresden.telekom.de>



hi,

I have a problem with BLOB and Context Cartridge together. I created the following table

DROP TABLE docs3
/

CREATE TABLE docs3
 (

  id                         NUMBER NOT NULL,
  text                       BLOB,
  title                      VARCHAR2(255)
 )
/

CREATE UNIQUE INDEX docs3_id_pk
 ON docs3 ( id )
/

ALTER TABLE docs3
 ADD CONSTRAINT docs3_id_pk PRIMARY KEY (id)
/

then I created the policy and the index

 execute CTX_DDL.create_policy('ctx_docs31','docs31.text');  execute CTX_DDL.create_INDEX('ctx_docs31');

if I update content of the table docs3, I get the following errror message:

ctxldr80 -user user1/user1_at_live -update -pk 1 -name ctx_docs3 -file c:\test.doc

ORA-20000: ConText error:
DRG-11527: Unknown message id 11527
ORA-06512: in "CTXSYS.DRUE", Zeile 180
ORA-06512: in "CTXSYS.CTX_DML", Zeile 336
ORA-06512: in Zeile 1

The same procedure works well with LONG and Context Cartridge together.

Any help will be greatly appreciated!

Samer Received on Thu Jul 22 1999 - 14:23:21 CEST

Original text of this message