[Q]: CONTEXT one-step query in PL/SQL procedure

Hi

[Quoted] [Quoted] Im trying to do the following CONTEXT query within PL/SQL. THis query works [Quoted] one hundred per cent using SQL*Plus, but will not compile when placed in PL/SQL. Anyone know why?

    select * from course where
     contains(content,s,1)>0 or
    contains(title,s,2)>0 and
    trainingunit = deptid
    order by score(2) desc, score(1) desc, title;

When this is placed in a PL/SQL procedure, I get an undeclared identifier "CONTAINS" message on compile. In SQL Plus or SQL Worksheet, this works fine. Received on Thu Feb 19 1998 - 00:00:00 CET