Creating Oracle Table Functions

Published: 25 Aug 2016
Last Modified Date: 23 Aug 2019


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


  • Tableau Desktop
  • Oracle


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?