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

From: Fat Boy Slim <fatty_at_boy.slim.com>
Date: 1998/02/19
Message-ID: <887888805.17602.0.nnrp-05.9e98628b@news.demon.co.uk>#1/1

Im trying to do the following CONTEXT query within PL/SQL. THis query works 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 CST