过程创建时出现编译错误.payment_count(l_p_count);*

Question

创建一个名为"payment_count"的过程，该过程接受一个以数字为数据类型的输出参数p_count。此过程应打印别名为"successful_payment_count"的成功付款计数(response_msg为"successful"(。提示：程序名称：payment_count输出参数：p_count使用的表：payment_authorization使用的功能：计数

create or replace procedure payment_count(p_count output number)
as
begin
select count(response_msg='Successful') into successful_payment_count from payment_authorization;
return successful_payment_count;
end;
/

模式支付_授权

Answer 1

这是考试中的任务吗？听起来…无论如何：

您必须将关键字输出更改为OUT，将COUNT(response_msg='Successful'(更改为COUNT，并将response_msg='Successful'添加到查询的where子句中。

Answer 2

create or replace procedure payment_count(p_count out number)
as
begin
select count(response_msg) as successful_payment_count 
into p_count
from payment_authorization
where response_msg = 'Successful';
end;
/