Stored procedure call working on one server but not on another

From: <ford_desperado_at_yahoo.com>
Date: 10 Feb 2005 11:34:14 -0800
Message-ID: <1108064054.468737.172760@z14g2000cwz.googlegroups.com>

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 Received on Thu Feb 10 2005 - 13:34:14 CST