Re: problem with stored procedure

From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Fri, 03 Mar 2006 08:28:15 +0200
Message-ID: <4407e1ff$0$10073$ba624cd0@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

Received on Fri Mar 03 2006 - 00:28:15 CST