存储过程中游标报错

[黑山老妖Hibbert]

create or replace procedure MONTH_SETTLE_ACCOUNT(startday date, endday date) as
last_costs number(8,2);
costs number(8,2);
patient_id varchar2(8);
operate_date date;
operator varchar2(8);
min_id number(2);
max_id number(2);
i number(2);

cursor r_cur1 is
select patient_id,visit_id,total_payments,discharge_date_time from pat_visit
where discharge_date_time >= startday and discharge_date_time < endday+1;
row_rec1 r_cur1%rowtype;

begin
...
end;

PLS-00201: identifier 'MEDREC.PAT_VISIT' must be declared

我已经grant select权限了，不知道为什么还是报错？

[jhhm]

是不是包里面有变量没有声明？

[chishuiqingshen]

pat_visit 没有这个表，或者是表不在你的方案中。