Selecting a count into a variable in oracle

Question

Hi I have been trying this today and haven't had any luck. this stored procedure does not work :(

CREATE OR REPLACE PROCEDURE LEAD_PURGE(closed IN DATE,
oprtr IN INTEGER,
leadscount OUT INTEGER)

is
BEGIN

SELECT COUNT(*) FROM LEADS_DELETED INTO leadscount;

COMMIT;
END LEAD_PURGE;

Answer 1

The INTO clause is misplaced. It should be:

SELECT COUNT(*) INTO leadscount FROM LEADS_DELETED