Oracle : query with contains won't work
| From: | Bertrand Mansion | Date: | Tue, 11 Dec 2001 15:46:53 +0000 |
| Subject: | Oracle : query with contains won't work | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-3452@lists.php.net to get a copy of this message | ||
Hi all,
This query won't work with oci8 PEAR DB wrapper :
select SCORE(1), DOC_NAME from DOC where contains(DOC_FILE,'finance',1)>0
This is supposed to be a classic query for accessing rows in an index (of
type Context in my case). DOC_FILE is the indexed blob column.
When I try to run this query this way :
$db = DB::connect($dsn);
$sql = "select SCORE(1), DOC_NAME from DOC where
contains(DOC_FILE,'finance',1) > 0";
$result = $db->query($sql);
$row = $result->fetchRow()
echo $row[0]."-".$row[1];
Even with getDebugInfo, it just keeps hanging and does not display anything
on screen. I am using the last CVS.
Do you know why ? Any ideas ?
Thanks
Bertrand Mansion
Mamasam