![]() |
| |||||||
![]() |
| | LinkBack | Thread Tools | Search this Thread | Display Modes |
| |||
| 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 |
![]() |
| Thread Tools | Search this Thread |
| Display Modes | |
| |