Re: Re: Oracle Problem Reports
Well,
this is what I have got until now:
To create a textual index (an index that can be used for textual queries)
you need to run a command like this one:
create index "tiki_comments_data_ft" on "tiki_comments"("data") indextype is ctxsys.context;
But after running the command I got:
ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-10582: column DATA does not exist in table tiki_comments ORA-06512: at "CTXSYS.DRUE", line 157 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 204
This error is a bug in Oracle versions from 8i to 9i, relative to the case sensitive sintax used
to create the tables. All database is created with the " mark in table, column and index names,
and is used within all the php pages.
Unfortunatly, there is not a patch for this bug in the Oracle version I am using (9ir2).
Is is corrected into the >=10g versions, but I don't think upgrade is an option for me
right now.
One option would be to remove all double quote references within all database queries into the
php code ( perhaps under the oci8 driver? ). If we do, the Oracle would be case insensitive,
and there will be no problem to create the textual index. I don't know if this would be easy to implement.
As I am not a PHP programmer, and have no PHP programmers to help me, I don't think I have enough time
to correct this by myself and probably will have to abandon my efforts.
The search feature have a very high importance in my context. So I think I will have to search for
other options.
If someone else could help me, fell free to contact me.