Siebel calls the Stored Procedure

BS script:

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;    }}

Configuration:

In System Preference of administrator-application, Set

Preferencename: sba_81_dsn; siebeltst; proc_update_account
Format: ODBC name; Siebel user password; stored procedure name
PS: the stored procedure will be discussed later.

Siebel calls the Stored Procedure