Tableau connecting to Teradata procedure with out parameters not showing

Question

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.

Answer 1

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;