Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009

    Unanswered: Stored Query Use

    Hi everyone,
    I am first time using Stored Query and facing some problem.
    I got some example on net about how to use stored query but I don’t know why it is not working in my case
    Please have a look on my attempt and tell me what mistake I am doing. Any help regards this will be very highly regretted.(May be I don’t know how to use SQE operator)

    My attempt:

    oracle@oracle2 ~$ sqlplus / as sysdba

    SQL*Plus: Release - Production on Mon Jul 6 12:21:32 2009

    Copyright (c) 1982, 2007, Oracle. All rights reserved.

    Connected to:
    Oracle Database 11g Enterprise Edition Release - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL> create user test identified by test;

    User created.

    SQL> grant connect,dba,resource,ctxapp to test;

    Grant succeeded.

    SQL> connect test/test@content;
    SQL> create table test (text varchar2(2000));

    Table created.

    SQL> insert into test values ('hello world');

    1 row created.

    SQL> create index testindex on test(text) indextype is ctxsys.context;

    Index created.

    SQL> exec ctx_query.store_sqe('testsqe', 'hello')

    PL/SQL procedure successfully completed.

    SQL> select * from test where contains (text, 'sqe(testsqe)') > 0;
    select * from test where contains (text, 'sqe(testsqe)') > 0
    ERROR at line 1:
    ORA-29902: error in executing ODCIIndexStart() routine
    ORA-20000: Oracle Text error:
    DRG-00100: internal error, arguments : 50935,http://drpn.c,1051],[,[]
    ORA-01403: no data found

    SQL> select * from test where contains (text, 'ctx_query.sqe(testsqe)') > 0;

    no rows selected


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    never mind
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2009
    Very sorry langauge mistake
    wanted to write:

    any help in this regards will be highly appriciated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts