Re: problem with stored procedure

"Arto Viitanen" <arto.viitanen_at_csc.fi> wrote in message news:4407e1ff$0$10073$ba624cd0_at_newsread.funet.fi...
> DA Morgan wrote:
> > Jean marc Parmentier wrote:
> >> Hi all,
> >> I have a weird problem.
> >> I am using an Oracle 9i DB and I wrote a stored procedure.
> >>
> >> The procedure works like a charm when I use SQL+:
> >> execute insert_stats('gggg',1,2,3,4,5,6,7,8);
> >>
> >> My problem is when I am using it from Visual Studio using sever
> >> explorer (ADO) and Oracle explorer
> >>
> >> Server Explorer / run stored procedure is returning:
> >> ORA-06550: line 1, column 13:
> >> PLS-00302: component 'INSERT_STATS' must be declared
> >> ORA-06550: line 1, column 7:
> >> PL/SQL: Statement ignored
> >
> > Nothing weird about it. Oracle's behaviour has been documented for
> > at least a decade. You must explicitly grant privileges on the table.
> > They can not be granted through a role.
>
> Are you sure? How does Oracle know that procedure is called via
> SQL*Plus and use the role or via Visual Studio and not use the role?
>
> (I have had the role problem and I think the error message was
> different)
>
> --
> Arto Viitanen, CSC Ltd
> Espoo, Finland

Daniel is correct on this one Received on Fri Mar 03 2006 - 19:49:19 CST