Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PHP4+Oracle Intermedia Text

Status
Not open for further replies.

MarcioFT

Programmer
Nov 20, 2001
1
BR
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


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top