Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP:ConText Option in PL/SQL
>I'm trying to use CONTAINS function in PL/SQL.
>But it break out with some errors.
The one-step CONTAINS, as in select .. where contains is meant for plain SQL statements only, and does not work in PL/SQL. In order to use CONTAINS in PL/SQL, you need to use the two-step contains:
begin
ctx_query.contains('policy','wine','result');
select textkey into key from result;
end;
With ORACLE 7.3.3/OCO 2.0, you can use the transparent contains with DBMS_SQL in PL/SQL blocks. Received on Mon Jun 30 1997 - 00:00:00 CDT