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
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC High)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC High)
Contact
Name Microsoft
URL Microsoft LogicApps Support
Microsoft Power Automate Support
Microsoft Power Apps Support
Connector Metadata
Publisher Microsoft
Website https://www.oracle.com/database/
Privacy policy https://www.oracle.com/legal/privacy/

To use this connector in Power Apps, 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.

Creating a connection

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

Name Type Description
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

Throttling Limits

Name Calls Renewal Period
API calls per connection150060 seconds

Actions

Delete row

This operation deletes a row from a table.

Execute stored procedure

This operation runs a stored procedure.

Get row

This operation gets a row from a table.

Get rows

This operation gets rows from a table.

Get tables

This operation gets tables from a database.

Insert row

This operation inserts a new row into a table.

Update row

This operation updates an existing row in a table.

Delete row

This operation deletes a row from a table.

Parameters

Name Key Required Type Description
Table name
table True string

Name of table

Row id
id True string

Unique identifier of the row to delete

Execute stored procedure

This operation runs a stored procedure.

Parameters

Name Key Required Type Description
Procedure name
procedure True string

Name of stored procedure

Parameters list
parameters True 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.

Parameters

Name Key Required Type Description
Table name
table True string

Name of Oracle table

Row id
id True 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.

Parameters

Name Key Required Type Description
Table name
table True string

Name of Oracle table

Filter Query
$filter string

An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).

Order By
$orderby string

An ODATA orderBy query for specifying the order of entries.

Top Count
$top integer

Total number of entries to retrieve (default = all).

Skip Count
$skip integer

The number of entries to skip (default = 0).

Select Query
$select 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.

Returns

Represents a list of tables.

Body
TablesList

Insert row

This operation inserts a new row into a table.

Parameters

Name Key Required Type Description
Table name
table True string

Name of table

Row
item True 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.

Parameters

Name Key Required Type Description
Table name
table True string

Name of table

Row id
id True string

Unique identifier of the row to update

Row
item True dynamic

Row with updated values

Returns

The outputs of this operation are dynamic.

Definitions

Table

Represents a table.

Name Path Type Description
Name
Name string

The name of the table. The name is used at runtime.

DisplayName
DisplayName string

The display name of the table.

TablesList

Represents a list of tables.

Name Path Type Description
value
value array of Table

List of Tables