在oracle中选择一个计数到变量中

Question

嗨，我今天一直在尝试这个，但没有任何运气。这个存储过程不起作用:(

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

INTO 子句放错了位置。应该是：

SELECT COUNT(*) INTO leadscount FROM LEADS_DELETED

Answer 2

您将 into 放在了错误的位置。

尝试这样的事情，然后从那里继续：

declare
  cnt number;
begin
  select count(*) 
  into cnt
  from leads_delete;
end;

Answer 3

另一种方式：

declare
  cnt number;
  cmd varchar2(100);
begin
  cmd := 'select count(*) from leads_delete';
  execute immediate cmd into cnt;
end;