Compilation errors for PACKAGE AUTH.TESTError: PLS-00103: Encountered the symbol ";" when expecting one of the following:
( return
Line: 24
Text: function AddMoveDataToOrignNas;
create or replace package test is
function AddMoveDataToOrignNas; //error
end test;
function AddMoveDataToOrignNas is
begin
insert into auth_base_orignasinfo(id,ipaddr,domain,node,cityid,countyid,orderby,modifydate,enabled,moved) values(Auth_Base_Orignasinfo_SEQ.Nextval,'10.10.10.10','NB-YY-SB-1_domain','57407','3102','310205',32,sysdate,1,1); return;
end AddMoveDataToOrignNas;
( return
Line: 24
Text: function AddMoveDataToOrignNas;
create or replace package test is
function AddMoveDataToOrignNas; //error
end test;
function AddMoveDataToOrignNas is
begin
insert into auth_base_orignasinfo(id,ipaddr,domain,node,cityid,countyid,orderby,modifydate,enabled,moved) values(Auth_Base_Orignasinfo_SEQ.Nextval,'10.10.10.10','NB-YY-SB-1_domain','57407','3102','310205',32,sysdate,1,1); return;
end AddMoveDataToOrignNas;
create or replace package test is
function AddMoveDataToOrignNas; //error
end test;
create or replace package body test is
function AddMoveDataToOrignNas is
begin
insert into auth_base_orignasinfo(id,ipaddr,domain,node,cityid,countyid,orderby,modifydate,enabled,moved) values(Auth_Base_Orignasinfo_SEQ.Nextval,'10.10.10.10','NB-YY-SB-1_domain','57407','3102','310205',32,sysdate,1,1); return;
end AddMoveDataToOrignNas;end test;
你還不如寫成procedure呢
//head
create or replace package test is
function AddMoveDataToOrignNas; //error
end test;
放头上的,// body
create or replace package body test is
function AddMoveDataToOrignNas is
begin
insert into auth_base_orignasinfo(id,ipaddr,domain,node,cityid,countyid,orderby,modifydate,enabled,moved) values(Auth_Base_Orignasinfo_SEQ.Nextval,'10.10.10.10','NB-YY-SB-1_domain','57407','3102','310205',32,sysdate,1,1); return;
end AddMoveDataToOrignNas;end test;跟你说的一样。
function AddMoveDataToOrignNas return number; -- 要有return類型
end test;
放头上的,// body
create or replace package body test is
function AddMoveDataToOrignNas is
begin
insert into auth_base_orignasinfo(id,ipaddr,domain,node,cityid,countyid,orderby,modifydate,enabled,moved) values(Auth_Base_Orignasinfo_SEQ.Nextval,'10.10.10.10','NB-YY-SB-1_domain','57407','3102','310205',32,sysdate,1,1); return 1; -- 要return 一個值
end AddMoveDataToOrignNas;end test;