COLUMN company_name HEADING company_name
COLUMN first_accept HEADING first_accept
COLUMN continue_accept HEADING continue_accept
COLUMN first_manage HEADING first_manage
COLUMN continue_manage HEADING continue_manage
COLUMN first_fetch HEADING first_fetch
COLUMN continue_fetch HEADING continue_fetch
COLUMN first_changed HEADING continue_changed
COLUMN comm_amount HEADING comm_amount
SET AUTOPRINT ON
VARIABLE cv REFCURSOR
execute VF_P_QUREY_OID.VF_QUREY_OID('1000000','2008-01-01','2008-01-31',cv);
我这个执行为什么总说我没有定义cv呀,我是从书上写的几乎一样呀
PLS-00201: identifier 'CV' must be declared
这是我调用的包头信息
--根据机构查询,建立VF_P_QUREY_OID包实现数据集返回
create or replace package VF_P_QUREY_OID IS--包头
type refcurosr is ref cursor;
--下面是有四个参数的过程
procedure VF_QUREY_OID(o_id in varchar2,--机构号
begin_time in varchar2,--起始日期
end_time in varchar2,--终止日期
o_query in out refcurosr);--返回的数据集end VF_P_QUREY_OID;
COLUMN first_accept HEADING first_accept
COLUMN continue_accept HEADING continue_accept
COLUMN first_manage HEADING first_manage
COLUMN continue_manage HEADING continue_manage
COLUMN first_fetch HEADING first_fetch
COLUMN continue_fetch HEADING continue_fetch
COLUMN first_changed HEADING continue_changed
COLUMN comm_amount HEADING comm_amount
SET AUTOPRINT ON
VARIABLE cv REFCURSOR
execute VF_P_QUREY_OID.VF_QUREY_OID('1000000','2008-01-01','2008-01-31',cv);
我这个执行为什么总说我没有定义cv呀,我是从书上写的几乎一样呀
PLS-00201: identifier 'CV' must be declared
这是我调用的包头信息
--根据机构查询,建立VF_P_QUREY_OID包实现数据集返回
create or replace package VF_P_QUREY_OID IS--包头
type refcurosr is ref cursor;
--下面是有四个参数的过程
procedure VF_QUREY_OID(o_id in varchar2,--机构号
begin_time in varchar2,--起始日期
end_time in varchar2,--终止日期
o_query in out refcurosr);--返回的数据集end VF_P_QUREY_OID;
execute VF_P_QUREY_OID.VF_QUREY_OID('1000000','2008-01-01','2008-01-31',cv);
cv在前面需要declare里面写的