存储过程中游标报错
create or replace procedure MONTH_SETTLE_ACCOUNT(startday date, endday date) aslast_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权限了，不知道为什么还是报错？ grant select 你也得指定user啊.
select patient_id,visit_id,total_payments,discharge_date_time from user.pat_visit
where discharge_date_time > = startday and discharge_date_time < endday+1;
页:
[1]