KNOWLEDGE BASE

Stored Procedures and Table Functions are Missing When Connecting to Oracle


Published: 15 Dec 2017
Last Modified Date: 18 Dec 2017

Issue

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

Environment

  • Tableau Desktop
  • Oracle

Resolution

  • 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:
    • the Oracle user whose credentials are being used to connect must also have permissions to access the Table Function,
    • the function must not be created in the SYS schema.

Cause

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?