Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [Q]ConText Cartridge & Stored Procedures
You can't create procedures on objects granted via a role. Grant explicit
EXECUTE access on the packages needed.
Thor HW
apavlov_at_pop.pitt.edu wrote in message <34FEDCBD.83504A22_at_pop.pitt.edu>...
>Hi,
>
>I could not find any helpfull docs about using Oracle 8 ConText
>Cartridge and Stored Prcedures.
>
>The SQL - select * from mpi where CONTAINS(address,'USA') > 0;
>
> works just fine, but when I try to create a SP I get :
>
>LINE/COL ERROR
>-------- ---------------------------------------------------
>5/23 PL/SQL: SQL Statement ignored
>5/47 PLS-00201: identifier 'CONTAINS' must be declared
>
>I've GRANTED all ctx roles to the user.
>
>create or replace procedure spGetXXX (
> refCursor IN OUT cursors.cMPI, country IN varchar2)
>as
>
>begin
>
> open refCursor for select * from mpi where CONTAINS(address,country)
>
>> 0;
>
>end;
>
>
>
Received on Wed Mar 11 1998 - 00:00:00 CST
![]() |
![]() |