Re: Stored procedure call working on one server but not on another

On 10 Feb 2005 11:34:14 -0800, ford_desperado_at_yahoo.com wrote:

>I have 2 servers
>the old one is running 9.2.0.1.0 on Red Hat Linux
>
>I login as STEST, both scripts below work
>
>this one:
>DECLARE a VARCHAR(100);
>begin
>STEST.GETNEXT_ID('ABC',1,a);
>end;
>
>as well as this one;
>DECLARE a VARCHAR(100);
>begin
>GETNEXT_ID('ABC',1,a);
>end;
>
>Another server is running 9.2.0.3.0 on Windows
>Again, I login as STEST,
>
>the first script fails:
>DECLARE a VARCHAR(100);
>begin
>STEST.GETNEXT_ID('ABC',1,a);
>end;
>ORA-06550: line 3, column 9:
>PLS-00302: component 'GETNEXT_ID' must be declared
>ORA-06550: line 3, column 1:
>PL/SQL: Statement ignored
>
>but the second one works all right
>DECLARE a VARCHAR(100);
>begin
>GETNEXT_ID('ABC',1,a);
>end;
>
>Any ideas?
>
>TIA
Are roles enabled?

Issue set role none and re-issue this statement. If it works now there is your answer: you have privilege through a role on one system (the non-functional one) and directly on the other system.

BTW this question is asked over and over and over again. One wonders when people start learning to do their own research and at least look the error message up in their docs, and search Google.

--
Sybrand Bakker, Senior Oracle DBA