刚刚碰到的一个错误, 还没找到原因呢.

数据库是9.2.0.6.0, 在Solaris 8上.

Logged on as ctxsys, tried to create a relation and got ORA-6512.

SQL> exec ctx_thes.create_thesaurus(‘CITY’,false);

PL/SQL procedure successfully completed

SQL> exec ctx_thes.create_phrase(‘CITY’,’DOWNSVIEW’);

PL/SQL procedure successfully completed

SQL> exec ctx_thes.create_relation(‘CITY’,’DOWNSVIEW’,’syn’,’DONMILLS’);

begin ctx_thes.create_relation(‘CITY’,’DOWNSVIEW’,’syn’,’DONMILLS’); end;

ORA-20000: Oracle Text error:
ORA-01403: no data found
ORA-06512: at “CTXSYS.DRUE”, line 157
ORA-06512: at “CTXSYS.CTX_THES”, line 345
ORA-06512: at line 1

SQL>

生产库是好的, 开发库也是好的, 就测试库有问题.

后来改用GUI做, 也是同样的错误. 但是多试几次后, 有些又可以加了. 晕啊.

出了这个错误到也有个好处, 让我从头到尾把ORACLE TEXT那本书看了一遍. 呵呵.



3 Comments to “Oracle Text Thesaurus error ORA-6512”

1. Yue.Guo — March 29, 2006 @ 8:47 pm
   

   solaris没有搞过,
   不过看你这个问题,呵呵,好像是ctxsys这个对象下的东西有问题,是不是安装的时候有什么不一样的地方?

2. greatfinish — March 30, 2006 @ 9:13 pm
   

   能把ctx_thes.create_relation这个里面的过程贴出来就好了。
   我猜想主要是ORA-01403: no data found这个原因有可能是你在过程中select xxx into xxx 产生了一个no_data_found的异常,但是时有时无的现象很难解释

   ORA-01403:no data found
   Cause:In a host language program, all records have been fetched. The return code from the fetch was +4, indicating that all records have been returned from the SQL query.
   Action:Terminate processing for the SELECT statement.

   我就连上面这个都没有看懂,是什么意思.

3. dosql — March 30, 2006 @ 10:42 pm
   

   ctx_thes.create_relation这个过程是看不到的. 有人建议用TRACE看, 可是我做了也没显示binding值.

Write a comment

You need tologin.