Can't get the CONTAINS operator to work within PL/SQL functions [message #76025] |
Mon, 03 March 2003 08:44 |
Sylvain
Messages: 3 Registered: December 2000
|
Junior Member |
|
|
Hello,
Here a piece of code from a PL/SQL file:
--------------------
FUNCTION is_similar(
param1 IN VARCHAR2,
param2 IN VARCHAR2,
weight IN INTEGER)
RETURN BOOLEAN
IS
nombre INTEGER;
BEGIN
SELECT COUNT(*) INTO number FROM cars
WHERE brand=param1
AND CTXSYS.CONTAINS(brand, '?' || param2);
RETURN ( number > 0 );
END;
------------------------
I always get the same error:
10/7 PL/SQL: SQL Statement ignored
10/105 PL/SQL: ORA-00920: unrecognized relational operator
It deals with my query using the CONTAINS operator. I ended up wondering wether it is possible to use it from PL/SQL or not...
Can anyone help ??
Sylvain
|
|
|
|