KNOWLEDGE BASE

Creating Oracle Table Functions


Published: 25 Aug 2016
Last Modified Date: 29 Aug 2016

Question

How to return a table via stored procedures when connected to an Oracle database.

Environment

  • Tableau Desktop 10.0.0
  • Oracle

Answer

use an Oracle Table Function to get a table through a stored procedure. 

1.      Define an object that stores a row of data.
2.      Define a table object to store the rows.
3.      Create a function that creates a row and stores it in the table object.

The Table Function will appear in the stored procedure section of the Tableau Desktop data source page. Drag your Table Function onto the canvas and fill out the parameter.

Did this article resolve the issue?