Connect to Oracle
Verb: oracleConnect
Available from: <Enterprise>
Connects to an Oracle database.
Syntax
oracleConnect --connectionstring(String) (DbConnection)=connection
Inputs
| Script | Designer | Required | AcceptedTypes | Description |
|---|---|---|---|---|
| --connectionstring | Connection String | Required | Text | Connection string for the Oracle Database.
There must be an Oracle Database previously configured. |
Outputs
| Script | Designer | AcceptedTypes | Description |
|---|---|---|---|
| connection | Connection | Database Connection | Variable that holds the connection to the Oracle database. |
Example
This example connects to an Oracle database, using the Assert Condition command to verify if the connection was successful. The message "Could not connect to the Database!" is displayed if the connection is empty.
defVar --name dbConnection --type DbConnection
// Connect to the database via the connection string and store the data in the connection variable.
oracleConnect --connectionstring "Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;\r\nIntegrated Security=no;" dbConnection=connection
// Check if the connection was successful
assert --message "Could not connect to the database!" --left "${dbConnection}" --operator "Is_Null" --negate