problem with stored procedure

From: Jean marc Parmentier <jmparmentier_at_gmail.com>
Date: 2 Mar 2006 11:48:19 -0800
Message-ID: <1141328899.319509.143940@t39g2000cwt.googlegroups.com>

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

No rows affected.
(0 row(s) returned)
Finished running DB."INSERT_STATS".

Oracle explorer / run is returning:

INSERT_STATS

ORA-20004: syntax error attempting to parser "DB"."INSERT_STATS"
ORA-06512: at "SYS.DBMS_DESCRIBE", line 87
ORA-04047: object specified is incompatible with the flag specified
ORA-06512: at line 1

Can someone tell me what is wrong, is it a rights problem?

Thanks,

---Jean-Marc Received on Thu Mar 02 2006 - 13:48:19 CST