Connect to Oracle

Verb: oracleConnect

Available from: <Enterprise>

Connects to an Oracle database.


oracleConnect --connectionstring(String) (DbConnection)=connection


Script Designer Required AcceptedTypes Description
--connectionstring Connection String Required Text Connection string for the Oracle Database.
There must be an Oracle Database previously configured.


Script Designer AcceptedTypes Description
connection Connection Database Connection Variable that holds the connection to the Oracle database.


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

See Also

  • Connect to MySQL
  • Connect to ODBC
  • Connect to PostgreSQL
  • Connect to SQL Server
  • Connect to SQLite