Discussion :

[InchRay]

Bonjour tout le monde;
J'ai un problème avec le trigger d'auto-incrémentation.
Erreur:PLS-00382:expression de mauvais type l'erreur indiqué est sur la ligne 2

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
 
CREATE OR REPLACE TRIGGER TG_2
BEFORE INSERT
ON DIMBASSIN 
FOR EACH ROW
BEGIN
    SELECT SEQ_AUTOINCR INTO:NEW.ID_BASSIN FROM DUAL;
END;

Le sequence SEQ_AUTOINCR:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
 
CREATE SEQUENCE SEQ_AUTOINCR
  START WITH 1
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 20
  NOORDER;

Est-ce que vous pouvez m'aider à résoudre ce problème ?
Je travaille sous Oracle 8i et j'utilise toad.
Merci d'avance.

[mnitu]

Lire la documentation n'a jamais fait du mal à personne.

A sequence is a schema object that can generate unique sequential values. These values are often used for primary and unique keys. You can refer to sequence values in SQL statements with these pseudocolumns:

•CURRVAL: Returns the current value of a sequence


•NEXTVAL: Increments the sequence and returns the next value


You must qualify CURRVAL and NEXTVAL with the name of the sequence:
sequence.CURRVAL
sequence.NEXTVAL


To refer to the current or next value of a sequence in the schema of another user, you must have been granted either SELECT object privilege on the sequence or SELECT ANY SEQUENCE system privilege, and you must qualify the sequence with the schema containing it:
schema.sequence.CURRVAL
schema.sequence.NEXTVAL


To refer to the value of a sequence on a remote database, you must qualify the sequence with a complete or partial name of a database link:
schema.sequence.CURRVAL@dblink
schema.sequence.NEXTVAL@dblink


A sequence can be accessed by many users concurrently with no waiting or locking.