TestProject Documentation
PlatformAddonsBlogForum
Search…
Welcome to TestProject!
Getting Started
Register and Collaborate
Installation and Setup
Create Your First Test
Why TestProject
Why Should You Use TestProject
What Makes TestProject Unique
Using AI to Improve Testing
TestProject Agents
What is a TestProject Agent?
How Does an Agent fit into the Ecosystem?
Hybrid Cloud and Offline Mode
TestProject Agent in Docker
TestProject Agent on Kubernetes
TestProject Agent CLI
Silent Deployment
Unregistered/Offline Agent
Smart Test Recorder
Web Testing
Mobile Testing
Create a Test Step
Finding and Using Elements
Available Actions
Available Validations
Step output validations
Using Data Driven Tests and Jobs in TestProject
Schedule and Run Tests
Manage TestProject Agents
Create and Schedule Jobs
Parallel Execution
Reports
Introduction to Reports in TestProject
Types of Plots in TestProject Reports
Individual Run Reports
Get Test Reports via API
Deleting old reports
TestProject Addons
What is an Addon?
Installing Community Addons from the store
Using Addons in the TestProject Recorder
Creating an Addon
Available Addons
Yaml Validator
Tap and Get Toast Message
XLSX Operations
Base64 Encoder/Decoder Addon
Shell Commands Addon
Android Monkey Addon
Android Permissions Manager Addon
Element Extensions Addon
Generic Extensions Addon
Geolocation Utils Addon
Get Attribute Value (Mobile)
Get Page Source (Mobile)
HTML Table Actions
iOS Wheel Picker
Image Comparison Addon
JS Actions Addon
Live Currency Converter Addon
Mobile Extensions Addon
Parameters Operations Addon
Reporting Utilities Addon
RESTful API Client
Scroll to Element Addon
Slack Actions Addon
Swipe and Find Element addon
Web Extensions Addon
Web Touch Gestures Addon
Random Values from CSV File Addon
CSV Operations Addon
Deep Link Toolkit Addon
Google Authenticator OTP Automation Addon
Visible Elements Operations Addon
Angular Element Actions Addon
Clicks Multiplier Addon
Natural Language Processing Engine Addon
ADB Wrapper Addon
Phone Numbers Addon
Date-Time Operations Addon
Random Data Generator Addon
iOS Network Operations Addon
Random Login Credentials Addon
Numeric Utils Addon
Android Key Events Addon
iOS Screen Orientation Addon
Math Calculations Addon
String Utils Addon
MSSQL Database Addon
MySQL Database Addon
PostreSQL Database Addon
Oracle Database Addon
Web List Operations Addon
File Uploader Addon
JSON Operations Addon
jQuery - Slider Addon
jQuery - Spinner Addon
jQuery - Progressbar Addon
jQuery - Checkboxradio Addon
jQuery Tabs Addon
jQuery - Dialog Addon
jQueryUI - Accordion Addon
Foundation - Accordion Addon
Robot Operations Addon
Foundation - Pagination Addon
Foundation - Orbit Addon
Foundation - Tabs Addon
KendoUI - Scheduler
KendoUI - Grid Addon
Bootstrap4 - Buttons Group Addon
Bootstrap4 - Dropdown Addon
Teradata Database Addon
Get Element Color
Google Actions
Open Source SDK
Overview
OpenSDK (v2)
Using OpenSDK within CI/CD
Using OpenSDK with BDD
Legacy SDK (v1)
Integrations
qTest Integration
BrowserStack Integration
Genymotion Desktop Integration
Jenkins Integration
TeamCity Integration
Sauce Labs Integration
Setting up Email Notification
Slack Integration
CircleCI Integration
GitHub Integration
TestProject API
RESTful API v2
Getting Started With Using the TestProject API
Articles
Help Articles
Tips And Tricks
Supported Environments
Releases
v3.5.0
v3.4.0
Older Versions
Contact us
Support
Knowledge Base
FAQs
Powered By GitBook
Oracle Database Addon
This addon allows you to test connections and to send queries to Oracle databases. You can use this addon to send an SQL query and get the response in JSON format. Then, you can compare this output with the UI data.

Available Actions

Send SQL Query (Oracle Database) - Send a SQL query to an Oracle Database
This action takes in the following input parameters:
  • Host - Name of the host machine where the database is (required)
  • Port - Port number to connect to (default port is 3306 if none specified)
  • Username - Username to connect to the database (required)
  • Password - Password for connecting to the database (required)
  • Query - The SQL query you want to execute
  • SID - System ID of the database you want to connect to (default is None if it is not specified)
  • Service - Service name (default is None if it is not specified)
Test SQL Connection (Oracle Database) - Test the connection to the Oracle database
This action takes in the following input parameters:
  • Host - Name of the host machine where the database is (required)
  • Port - Port number to connect to (default port is 3306 if none specified)
  • Username - Username to connect to the database (required)
  • Password - Password for connecting to the database (required)
  • SID - System ID of the database you want to connect to (default is None if it is not specified)
  • Service - Service name (default is None if it is not specified)
Previous
PostreSQL Database Addon
Next
Web List Operations Addon
Last modified 2yr ago
Copy link