Skip to main content
Topics#Tableau APIs & EmbeddingTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau APIs & Embedding
Jul 16, 2015, 10:54 AM

Oracle Stored Procedure giving error "does not return a result set, or the result set columns do not have names"

Hi,

 

I am trying to run a stored procedure from Tableau 9.0 version and I am getting the below error

 

"

The Stored Procedure "XXX" does not return a result set, or the result set columns do not have names.

Unalb eto connect to the server "server XXX". Check that the server is running and that you have access previleges to the requested database."

 

The Stored Procedure contains parameters and when we run this from database by passing required parameters it is working fine.

 

But when we tried to connect to this Stored Procedure from Tableau by selecting the parameter values, It throws the above error.

 

Can any one help me on this.

 

Thanks

4 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Jul 20, 2015, 6:40 AM

    Sorry All. The Stores Procedure is SQL Server Stored Procedure and not Oracle Stored Proceudre.

     

    Adding the syntax SET NOCOUNT ON in the SP solved our Problem.

     

    Thanks once again for your responses.

Write an answer...
0/9000