NVL function 1

[howzatUK]

Can anyone please tell me why the following procedure does not work?

I have tried everything, and it just wont work, compilation messages in the past have stated that it requires an 'INTO' clause, but adding this makes no difference and only produces another compilation error. PLEASE HELP?????????

CREATE OR REPLACE PROCEDURE GenNewActionKeys
AS
inewKey number;
BEGIN
inewKey:= max NVL(actionkey,0)+1 from dcactkey;
END;

 

[lewisp]

CREATE OR REPLACE PROCEDURE GenNewActionKeys
AS
  inewKey number;
BEGIN
  SELECT max(NVL(actionkey,0))+1
  INTO  inewKey
  from   dcactkey;
END;

 

[howzatUK]

Thankyou, obviously when i said i tried everything, i hadnt tried that combination. Thanks so much