create or replace package body CONFIRMATION_LETTER_PKG as
function ZYnerate_daily_records return boolean is
begin
insert into RC_CONFIR_LETTER_REQ_OFFER_DTL
values('3','4','ds','fsdf');
return (true);
end;
--begin
-- Initialization
end CONFIRMATION_LETTER_PKG ;
上面是我的代码,编译老说PLS00201:必须说明标示符'CONFIRMATION_LETTER_PKG'网上查询说是权限问题,修改了还是没有用啊,请各位大侠帮帮忙,急急急急!!
function ZYnerate_daily_records return boolean is
begin
insert into RC_CONFIR_LETTER_REQ_OFFER_DTL
values('3','4','ds','fsdf');
return (true);
end;
--begin
-- Initialization
end CONFIRMATION_LETTER_PKG ;
上面是我的代码,编译老说PLS00201:必须说明标示符'CONFIRMATION_LETTER_PKG'网上查询说是权限问题,修改了还是没有用啊,请各位大侠帮帮忙,急急急急!!
function ZYnerate_daily_records return boolean is
begin
insert into RC_CONFIR_LETTER_REQ_OFFER_DTL
values('3','4','ds','fsdf');
return (true);
end;
--begin
-- Initialization end CONFIRMATION_LETTER_PKG ;
以上代码中在return(true)前应该完成本次事务的提交。commit;
在建立包体前,应该建立先CONFIRMATION_LETTER_PKG包头,并在包头中声明ZYnerate_daily_records 函数如:function ZYnerate_daily_records return boolean;。
需要先创建包头create or replace package CONFIRMATION_LETTER_PKG as
function ZYnerate_daily_records return boolean;
end;
/create or replace package body CONFIRMATION_LETTER_PKG as
function ZYnerate_daily_records return boolean is
begin
insert into RC_CONFIR_LETTER_REQ_OFFER_DTL
values('3','4','ds','fsdf');
return (true);
end;
--begin
-- Initialization
end CONFIRMATION_LETTER_PKG ;