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.
As always with PL/SQL testing, issue a 'set role none' before
doing anything else.
If your code work with that, it has all privileges needed.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Fri Mar 03 2006 - 14:36:37 CST
