Oracle Database

Oracle Database

Oracle Database is a relational database management system developed by Oracle. Connect to on-premise Oracle Database to perform various actions such as create, update, get, and delete on rows in a table.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
Flow Premium All Flow regions
PowerApps Premium All PowerApps regions

To use this connector in PowerApps, learn more here.

What's new

The following are new updates and capabilities of Oracle connector

January 2018

  • Support Oracle view as read-only table

October 2018

  • Support Oracle Stored Procedure

Known issues and limitations

The followings are some of the known limitations of using Oracle connector

  1. When invoking a Stored Procedure on an Oracle server, we have the following limitations:
    • OUT parameters are not supported currently.
    • Return value is not available since Oracle Stored Procedure does not return any result.
  2. Oracle Functions are not supported so they are not listed in the UI.
  3. The response size limit is 8MB.
  4. Oracle native query is not supported.

Throttling Limits

Name Calls Renewal Period
API calls per connection 300 60 seconds

Creating a connection

To connect your account, you will need the following information:

Server
string
Specify the Oracle Server. If a port or SID is required, specify in the form of ServerName:Port/SID.
Authentication Type [Select Basic]
string
Authentication type to connect to your database
Username
securestring
Username credential
Password
securestring
Password credential
Gateway
gatewaySetting

Actions

Delete row

This operation deletes a row from a table.

Required Parameters

Table name
string
Name of table
Row id
string
Unique identifier of the row to delete

Execute stored procedure

This operation runs a stored procedure.

Required Parameters

Procedure name
string
Name of stored procedure
Parameters list
dynamic
Input parameters to the stored procedure

Returns

The outputs of this operation are dynamic.

Get row

This operation gets a row from a table.

Required Parameters

Table name
string
Name of Oracle table
Row id
string
Unique identifier of the row to retrieve

Returns

The outputs of this operation are dynamic.

Get rows

This operation gets rows from a table.

Required Parameters

Table name
string
Name of Oracle table

Optional Parameters

Filter Query
string
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Order By
string
An ODATA orderBy query for specifying the order of entries.
Top Count
integer
Total number of entries to retrieve (default = all).
Skip Count
integer
The number of entries to skip (default = 0).
Select Query
string
Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

Get tables

This operation gets tables from a database.

Required Parameters

Table name
string
Name of table
Row id
string
Unique identifier of the row to delete

Returns

Body
TablesList

Represents a list of tables.

Insert row

This operation inserts a new row into a table.

Required Parameters

Table name
string
Name of table
Row
dynamic
Row to insert into the specified table

Returns

The outputs of this operation are dynamic.

Update row

This operation updates an existing row in a table.

Required Parameters

Table name
string
Name of table
Row id
string
Unique identifier of the row to update
Row
dynamic
Row with updated values

Returns

The outputs of this operation are dynamic.

Definitions

Table

Represents a table.

DisplayName
string
The display name of the table.
Name
string
The name of the table. The name is used at runtime.

TablesList

Represents a list of tables.

value
array of Table
List of Tables