Editing the CallPLSQL Business Service

Use the following procedure to edit the CallPLSQL business service.

To edit the CallPLSQL business service

Query for the CallPLSQL business service and click on the Business Service Server Script node.

Within the CallPLSQL business service, edit its script attribute as shown in the following example:

function CallPLSQL(Inputs, Outputs)
  {var vImptJobId;
  var cmdString;
  vImptJobId = Inputs.GetProperty("ImportJobId");
  Clib.sprintf(cmdString, "<absolute path of the sqlplus.exe file on the Siebel Server> <DB table owner username>/<DB table owner password>@<database table owner> @<absolute path of callplsql.sql file> %s", vImptJobId);
    Clib.system(cmdString);
  return (ContinueOperation);
  }

Edit the line highlighted in bold text to point to the:
- sqlplus executable on the Siebel Server
- User name (the name of the table owner) and password (the password of the database table owner)
- @local_SID (database name in the .ini file) of the database you are connected to
- The location of the callplsql.sql script
For example, on a Solaris environment, the line would look like:
```
/u01/app/oracle/product/11.2.0.3/dbhome_1/bin/sqlplus ORAPERF/ORAPERF@ORAPERF @/home/oracle/siebel/81114_23044_app4/siebsrvr/temp/callplsql.sql
```
Where
```
 /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/sqlplus 
```
is the path of the sqlplus executable

ORAPERF/ORAPERF@ORAPERF are the connection credentials and

@/home/oracle/siebel/81114_23044_app4/siebsrvr/temp/callplsql.sql is the path of the callplsql.sql script

The callplsql.sql file is located in the <build folder>/ses>/dbsrvr/oracle/ and <build folder>/ses/siebsvr/sqltempl/ folders.

Note: The sqlplus executable is usually located in the ORACLE_HOME/bin folder where ORACLE_HOME is your environment variable that points to the Oracle home directory.

For example, on the Linux platform:
```
Clib.sprintf(cmdString,
"<absolute path of the sqlplus.exe on the siebel server> <DB table owner username>/<DB table owner password>@<database table owner> @<absolute path of mktg_listimp_callplsql.sql file> %s", vImptJobId);
```
The path to the callplsql.sql script is <absolute path to mktg_listimp_callplsql.sql>

In Siebel Tools, it would look like:
```
function CallPLSQL(Inputs, Outputs)
  {var vImptJobId;
  var cmdString;
  vImptJobId = Inputs.GetProperty("ImportJobId");
  Clib.sprintf(cmdString, "<absolute path of the sqlplus.exe file on the Siebel Server> <DB table owner username>/<DB table owner password>@<database table owner> @<absolute path of callplsql.sql file> %s", vImptJobId);
  Clib.system(cmdString);
  return (ContinueOperation);
  }
```
When you have finished editing the script attribute, deploy the business service to the Siebel runtime repository.