Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP:ConText Option in PL/SQL

Re: HELP:ConText Option in PL/SQL

From: Garrett Kaminaga <gkaminag_at_gkaminag-sun.us.oracle.com>
Date: 1997/06/30
Message-ID: <5p95s9$41e$1@inet16.us.oracle.com>#1/1

>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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US