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.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Mar 02 2006 - 15:05:21 CST
