PL/SQL compilation error

[Eric Benoit]

Hi,
How can I resolve the compilation error :
INSERT INTO Paiement VALUES(seq_noPaiement.nextval, noLiv, myDate);
dbms_output.put_line('NoPaiement : ' || seq_noPaiement.currval);
The error occurs when I do the put_line with seq_noPaiement.currval...
I also tried to do this :
myVar := seq_noPaiement.nextval;
INSERT INTO Paiement VALUES (myVar, noLiv, myDate);
dbms_output.put_line('NoPaiement : ' || myVar);
But it didn't work too...
So I don't have any idea about how to resolve this ... ???
Thansk,
Eric

[Remar Uy]

You can't use the CURRVAL pseudocolumn on the DBMS_OUTPUT call.
Try this link.
Hope that helps

[Remar Uy]

You can try this code:

 
DECLARE
  v_seqnum  NUMBER;
BEGIN
  INSERT INTO Paiement( <col1>, <col2>, <col3> :wink:  
   VALUES (seq_noPaiement.nextval, noLiv, myDate)
   RETURNING <col1> INTO v_seqnum;
  dbms_output.put_line('NoPaiement :'|| v_seqnum);
END;

[Eric Benoit]

Thanks a lot!