Stored Procedures and Table Functions are Missing When Connecting to Oracle

Published: 15 Dec 2017
Last Modified Date: 20 Jun 2019


When connecting to an Oracle data source in Tableau Desktop, Stored Procedures and Table Functions are missing.


  • Tableau Desktop
  • Oracle


  • It is currently not possible to use a Stored Procedure from an Oracle datasource in Tableau Desktop, but a Table Function can be used instead of a Stored Procedure.
  • For a Table Function to be displayed under the 'stored procedures' section in Tableau Desktop keep the following two things in mind:
    1. The Oracle user whose credentials are being used to connect must also have permissions to access the Table Function.
    2. The function must not be created in the SYS schema.


A stored procedure does not return data in a format compatible with Tableau, where a Table Function does. Oracle users must be given permission to Table Functions just like to regular databases.
Did this article resolve the issue?