Last Modified Date: 20 Jun 2019
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 keep the following two things in mind:
- 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.Additional Information
Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials