WebADI_Notes.docVIP

Notes for WebADI 準備工作: 找出WebADI repsponsibility的 Top Menu Responsibility: Desktop Integration Responsibility: Desktop Integrator Menu: Desktop Integration Menu 加上Submenu: HR ADI Seeded Integrator Form Functions 2. 修改 System Profile Profile: BNE% Profile: BNE Allow No Security Rule = Yes 3. Excel, 安全性設定 “信任存取VB 專案” 打勾. 4. IE, 安全性設定 a. 網際網路, 把ActiveX and Plug-ins功能都Enable b. 或加到信任網站 開始: Create Document: create table xxcus.xxcus005( c1 varchar2(50), c2 varchar2(50), c3 varchar2(50), c4 varchar2(50), c5 varchar2(50)); create or replace package xxcus_webadi is procedure xxcus005(p_out1 out varchar2, p_in1 in varchar2, p_in2 in varchar2, p_in3 in varchar2, p_in4 in varchar2, p_in5 in varchar2);end;create or replace package body xxcus_webadi is procedure xxcus005(p_out1 out varchar2, p_in1 in varchar2, p_in2 in varchar2, p_in3 in varchar2, p_in4 in varchar2, p_in5 in varchar2) IS begin INSERT INTO xxcus.XXCUS005 VALUES (p_in1, p_in2, p_in3, p_in4, p_in5); end;end;  Define Layout: Define Mapping (Optional)