I have this situation:
Table (oracle): Create table TEXTO
(Codigo varchar2(8) not null,
Descricao clob);
Index (Intermedia): Create index texto_ind on
TEXTO(descricao) indextype is
ctxsys.context;
Problem: when use sql instruction
"select codigo from TEXTO
where contains(descricao,'mysearch',1)>0"
in php4 Ociparse/ociexecute, they didn´t recognize
clause "contains" and return error message.
Can you help me?
Márcio Freire Teixeira
Table (oracle): Create table TEXTO
(Codigo varchar2(8) not null,
Descricao clob);
Index (Intermedia): Create index texto_ind on
TEXTO(descricao) indextype is
ctxsys.context;
Problem: when use sql instruction
"select codigo from TEXTO
where contains(descricao,'mysearch',1)>0"
in php4 Ociparse/ociexecute, they didn´t recognize
clause "contains" and return error message.
Can you help me?
Márcio Freire Teixeira