This documentation is for WSO2 Data Services Server 3.2.2. View documentation for the latest release.
Page Comparison - Calling MySQL or Oracle Functions in a Query (v.2 vs v.3) - Data Services Server 3.2.2 - WSO2 Documentation

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Given below is how to add a MySQL/Oracle function call to a data service.

Table of Contents
maxLevel3
minLevel3

Calling a MySQL function

Assume you have the following MySQL function, which takes a string parameter and returns the same as output. Create a database before executing the query.

...

You can also call this function in the Query Details page of the management console as follows:

Calling an Oracle function

Assume you have the following Oracle stored function, which returns the total number of entries in a table:

...