Skip to Main Content

SQL & PL/SQL

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!

ORA-20000: Oracle Text error: DRG-10599: column is not indexed

Christy H.Mar 27 2012 — edited Mar 27 2012
Hello,

My tables:
create table DetailResume(
d_id number(14) primary key,
cv_id number(14) constraint DetailResume_fk references CvProperties(cv_id),
cat_id number(14) constraint DetailResume_fk2 references CvCategories(cat_id),
DetailResume clob);

create sequence DetailResume_seq
start with 1 increment by 1;

create or replace trigger DetailResume_trig
before insert on DetailResume
referencing new as new
for each row
begin 
select DetailResume_seq.nextval into :new.d_id from dual;
end;
/
After giving respective grants to the user I have created this index
CREATE INDEX idx_detailResume ON detailResume(detailResume)
INDEXTYPE IS CTXSYS.CONTEXT;
Now I am making query as follow and its working fine:
SELECT SCORE(1), cv_id FROM detailResume WHERE CONTAINS(detailResume, 'cardiology', 1) > 0 and cat_id=5 order by SCORE(1) desc;
When I am using into my Java program:
String query = " SELECT SCORE(1), cv_id FROM detailResume WHERE CONTAINS(detailResume,'cardiology', 1) > 0 and cat_id=5"; 

		String query1 = " insert into jobResponses(job_id,cv_id,responseStatus) values (?,?,0)";       

		PreparedStatement ps=cnn.prepareStatement(query);		

		rs=ps.executeQuery();
		while(rs.next()){
		String score = rs.getString(1);
		String cvId = rs.getString(2);
		}
		ps.close();
		rs.close();						
		cnn.commit();
		cnn.close();
Then its throwing the following error:
java.sql.SQLException: ORA-20000: Oracle Text error:
DRG-10599: column is not indexed
Please advise

Thanks in anticipation
This post has been answered by Azhar Husain on Mar 27 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2012
Added on Mar 27 2012
6 comments
19,286 views