Connect Oracle Database to Loqate

Both apps 20Oracle Database 12Loqate 8

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected Oracle database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected Oracle database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

• Action
  Find address

  Searches Loqate for addresses and places matching the search text. Results of type Address carry an Id you can pass to Retrieve; other types are containers you drill into by passing their Id as the container.

• Action
  Geocode address

  Returns the WGS84 latitude and longitude for a postal code or place name in a given country.

• Action
  Retrieve address

  Returns the fully formatted address for an address Id returned by Find address.

• Action
  Reverse geocode address

  Returns the nearest street addresses to a WGS84 latitude/longitude coordinate, internationally.

• Action
  Validate bank account

  Validates a UK bank account number and sort code, returning the corrected BACS details, IBAN, holding branch and supported payment services.

• Action
  Validate email address

  Checks whether an email address exists, returning its validation status, risk level and whether it is a disposable mailbox. Consumes Loqate credit.

• Action
  Validate phone number

  Verifies whether a phone number is valid and returns network/line-type details.

• Action
  Verify address

  Verifies and standardizes one postal address against Loqate's international reference data, returning the cleansed address with its Address Verification Code (AVC) and quality indicators.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.