Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Stored procedure call working on one server but not on another

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

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Thu, 10 Feb 2005 22:23:51 +0100
Message-ID: <51kn01hkoi6bj8jp8f3f2mv3hqg8u17t2v@4ax.com>


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
Received on Thu Feb 10 2005 - 15:23:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US