Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> HELP:ConText Option in PL/SQL
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:
![]() |
![]() |