ConText Problem

Problem in Brief:

1.ctx_query.contains( 'BDO_ABS_TITLE_POL', textTerm,
'BDOWEBWISE_QUERY_RESULTS',1,2,0,1, 'enddate <= ''
'||to_date(endDate,'DD-MON-YY')||' '' ' );

2.ctx_query.contains( 'BDO_ABSTRACTS_POL', textTerm,
'BDOWEBWISE_QUERY_RESULTS',1,1,0,1, NULL);
The tables and the polices are in a schema called 'BDOWEBWISE'.The above

lines are in a procedure owned by BDOWEBWISE.

EXECUTE privs on the procedure and SELECT privs on the table has been granted to a user called' BDO_AERO'.

The difference between the 2 lines above are, first has a WHERE clause but
the second has NO WHERE clause.

Being a BDOWEBWISE ( owner of everything) I am able to run both the calls.

But when I am BDO_AERO, I am able to run the call WITHOUT the WHERE clause.
But call with the WHERE clause gives the following error.

sqlcode : -20000 sql message: ORA-20000: ConText error: DRG-10801: text query failed ORA-00942: table or view does not exist

BDO_ABSTRACTS_POL is on a table called

BDOWEBWISE_ABSTRACTS

• -------- ----

 DOCH_ID                         NOT NULL NUMBER(15)

 PROJECT_NO                      NOT NULL VARCHAR2(30)

 ABSTRACT                                 LONG

 CLASSIFIED                               VARCHAR2(10)

 PROPRIETARY                              VARCHAR2(10)

 INTERNAL_RELEASE                         VARCHAR2(10)

 PUBLIC_RELEASE                           VARCHAR2(10)

 CREATE_DATE                              DATE

 CREATE_USER                              VARCHAR2(25)

 EDIT_DATE                                DATE

 EDIT_USER                                VARCHAR2(25)

 TITLE                                    VARCHAR2(75)

 STARTDATE                                DATE

 ENDDATE                                  DATE

The policy is defined on the ABSTRACT column.

Any help would be appreciated.

Thanks,
Raj Received on Wed Apr 01 1998 - 00:00:00 CST