Voici ce qui est obtenu:
Serveur HP UX 11.11
version oracle 9.2.0.4
EN sql ça fonctionne mais pas en plsql!!!!
Please Help me!!!
Voici l’ erreur :
SQL> @essai.sql
SELECT SEQ_NUIOCECT.NEXTVAL INTO vSEQ FROM DUAL;
*
ERROR at line 289:
ORA-06550: line 289, column 16:
PL/SQL: ORA-02289: sequence does not exist
ORA-06550: line 289, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 364, column 8:
PL/SQL: ORA-02289: sequence does not exist
ORA-06550: line 364, column 1:
PL/SQL: SQL Statement ignored
ORA-06550: line 366, column 55:
PLS-00201: identifier 'VSEQ' must be declared
ORA-06550: line 366, column 1:
PL/SQL: Statement ignored
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Producti
on
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Partager