CODEWITHSUNDEEP
teradatatableau-apiprocedureout-parameters
Ling
Ling

Reputation: 359

Tableau connecting to Teradata procedure with out parameters not showing

I need to save a few parameters into Teradata via Tableau, I created a Teradata procedure to do insertion but when I connect to the procedure in Tableau it kept on giving me error "xxxx stored procedure returned no result. bla bla".

In order to make stored procedure returns some result, I update the Teradata procedure to include a OUT parameter to return a dummy message, but in the list of Stored Procedures under Tableau connection, all procedures with OUT parameter are not showing.

Appreciate if anybody can help.

Upvotes: 0

Views: 191

Answers (1)

Fred
Fred

Reputation: 2080

Tableau does not support procedure OUT parameters. You need the procedure to return a result set, e.g.

REPLACE PROCEDURE myProc(someInput INTEGER,...)
...
DYNAMIC RESULT SETS 1
...
BEGIN
DECLARE csr CURSOR WITH RETURN FOR SELECT 'OK';
...
OPEN csr;
END;

Upvotes: 1

Related Questions