首页 > 代码库 > Siebel 调用存储过程

Siebel 调用存储过程

2024-07-22 20:57:30   219人阅读

BS脚本：

function ExecuteOraclePrc(objectId,preferenceName){    try    {        var outMsgs = "";        var preference = GetPreference(preferenceName);        var prefArray = preference.split(";");        var dataSource =  prefArray[0];        var password = prefArray[1];        var prcName = prefArray[2];                var bsQuoteMsg = TheApplication().GetService("EAI ODBC Service");        var psInputs = TheApplication().NewPropertySet();        var psOutputs = TheApplication().NewPropertySet();        psInputs.SetProperty("ExtDBODBCDataSource", dataSource);        psInputs.SetProperty("ExtDBPassword", password);        psInputs.SetProperty("ExtDBTableOwner", "SIEBEL");        psInputs.SetProperty("ExtDBUserName", "SIEBEL");        psInputs.SetProperty("ProcedureArgument", objectId);        psInputs.SetProperty("ProcedureName",prcName);        bsQuoteMsg.InvokeMethod("ExecuteProc", psInputs, psOutputs);        outMsgs = psOutputs.GetProperty("Status");        return outMsgs;    }    catch(e)    {        throw e;        return outMsgs;    }    finally    {        psInputs = null;        psOutputs = null;        bsQuoteMsg = null;        prefArray = null;    }}

配置：

在Administrator-Application 的System Preference里，设置

preferenceName ：SBA_81_DSN;siebeltst;PROC_UPDATE_ACCOUNT
格式：ODBC NAME;siebel用户密码;存储过程名
PS:存储过程日后再谈。

Siebel 调用存储过程


联系
我们