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 -> HELP:ConText Option in PL/SQL

HELP:ConText Option in PL/SQL

From: Takayuki Kitayama <taka_at_osaka.dcl.co.jp>
Date: 1997/06/30
Message-ID: <5p77te$rav$1@neptune.osaka.dcl.co.jp>#1/1

Hello.

I'm trying to use CONTAINS function in PL/SQL. But it break out with some errors.
Please tell me that reason?
(Oracle 7.3.2, PL/SQL 2.3.2.2 on HPUX 10.20)

This is simple example:

declare

    key varchar2(16);
begin

    select text_key into key
    from text_view
    where CONTAINS(text, 'wine')>0;
end;
/

ERROR at line 6:

ORA-06550: line 6, column 7:
PLS-00201: identifier 'CONTAINS' must be declared
ORA-06550: line 4, column 1:

PL/SQL: SQL Statement ignored

taka_at_osaka.dcl.co.jp Received on Mon Jun 30 1997 - 00:00:00 CDT

Original text of this message

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