GEO˵ĳװ
1:ű

  execute dbms_java.grant_permission('GEO','SYS:java.net.SocketPermission','localhost','connect,resolve');
  execute dbms_java.grant_permission('EPB','SYS:java.net.SocketPermission','192.168.0.142','connect,resolve');
  execute dbms_java.grant_permission('GEO','SYS:java.net.SocketPermission','192.168.0.112','connect,resolve');

2:loadjava (ǰDatabaseJServer)
  dos,
  loadjava -u geo/inet21@orcl -r -v -f E:\pan\i1_Excel\i1_WebService\Report_Mail\Java\Project\deploy\epb_Excel_Mail.jar 


---------------------------------------------------------------------------------------------------------------------
declare
	varPK_NO   number;
begin
select SEQ_REC_KEY.NEXTVAL into varPK_NO from dual;
insert into Excel_Param_Mas_Buffer(REF_PK_NO,PK_NO,ORG_ID,ORG_NAME,LOC_ID,LOC_NAME,USER_ID,USER_NAME,NAME,MAIL_FROM,MAIL_TO,MAIL_CC,
	REPORT_CODE,MSG_SUBJECT,MSG_HEADER,MSG_BODY,MSG_FOOTER,NEED_MAIL,NEED_FAX,FAX_NUMBER)
 values(1111,varPK_NO,1,'ORG_NAME',1,'LOC_NAME',1,'SYSADM','ADMIN NAME','zwpan@epbrowser.com','zwpan@iplatformtech.com','',
    	'EXAMPLE','MSG_SUBJECT @REPORT_CODE@ - @REPORT_NAME@ @URL@',
'MSG_HEADER @REPORT_CODE@ - @REPORT_NAME@ @URL@',
'MSG_BODY @REPORT_CODE@ - @REPORT_NAME@ @URL@',
'MSG_FOOTER @REPORT_CODE@ - @REPORT_NAME@ @URL@',
'Y','N','9 63376298'
);

insert into Excel_Param_Dtl_Buffer(MAS_PK_NO,PK_NO,Param_CODE,Param_Value,Param_Value2)
 values(varPK_NO,SEQ_REC_KEY.NEXTVAL,'P_P1','P_P11','P_P12');
insert into Excel_Param_Dtl_Buffer(MAS_PK_NO,PK_NO,Param_CODE,Param_Value,Param_Value2)
 values(varPK_NO,SEQ_REC_KEY.NEXTVAL,'P_P2','P_P21','P_P22');
insert into Excel_Param_Dtl_Buffer(MAS_PK_NO,PK_NO,Param_CODE,Param_Value,Param_Value2)
 values(varPK_NO,SEQ_REC_KEY.NEXTVAL,'P_P3','P_P31','P_P32');

commit;
end;
/

call dbms_java.set_output(2000);
set serverout on
declare
   aa VARCHAR2(4000);
begin
   aa := EP_AUTOMAIL.fMail_Trigger();
   DBMS_OUTPUT.PUT_LINE(aa);
end;
/

---------------------------------------------------------------------------------------------------------------------
declare
	varPK_NO   number;
begin
select SEQ_SYS_PK_NO.NEXTVAL into varPK_NO from dual;
insert into Excel_Param_Mas_Buffer(REF_PK_NO,PK_NO,ORG_NO,ORG_NAME,LOC_NO,LOC_NAME,USER_NO,USER_NAME,NAME,MAIL_FROM,MAIL_TO,MAIL_CC,
	REPORT_CODE,MSG_SUBJECT,MSG_HEADER,MSG_BODY,MSG_FOOTER,NEED_MAIL,NEED_FAX,FAX_NUMBER)
 values(1111,varPK_NO,1,'ORG_NAME',1,'LOC_NAME',1,'SYSADM','ADMIN NAME','bear_pan@hotmail.com','zwpan@i1.com','zwpan@i1.com',
    	'','MSG_SUBJECT @REPORT_CODE@ - @REPORT_NAME@ @URL@',
'MSG_HEADER @REPORT_CODE@ - @REPORT_NAME@ @URL@',
'MSG_BODY @REPORT_CODE@ - @REPORT_NAME@ @URL@',
'MSG_FOOTER @REPORT_CODE@ - @REPORT_NAME@ @URL@',
'Y','N','9 63376298'
);

insert into Excel_Param_Attach_Buffer(MAS_PK_NO,PK_NO,URL,ATTACHUSER,ATTACHPWD)
 values(varPK_NO,SEQ_SYS_PK_NO.NEXTVAL,'ftp://localhost/test/aa.txt','administrator','panzhi');
insert into Excel_Param_Attach_Buffer(MAS_PK_NO,PK_NO,URL,ATTACHUSER,ATTACHPWD)
 values(varPK_NO,SEQ_SYS_PK_NO.NEXTVAL,'ftp://localhost/test/bb.xml','administrator','panzhi');

commit;
end;
/

call dbms_java.set_output(2000);
set serverout on
declare
   aa VARCHAR2(4000);
begin
   aa := I1_EXCEL_REPORT.fMail_Trigger();
   DBMS_OUTPUT.PUT_LINE(aa);
end;
/




