How to Save Data into Tearadata Volatile Table from Teradata stored procedure?
<p>I am trying to save the dataset that I get from executing a stored procedure. I tried the following query to call this stored procedure, but it did not work. Here is the error I get.</p>

<blockquote>
  <p>CREATE TABLE Failed. 3707: Syntax error, expected something like a
  name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword or
  a 'SELECT' keyword or '(' between '(' and the 'CALL' keyword.</p>
</blockquote>

<pre><code>CREATE VOLATILE TABLE #TEST AS 
(SELECT * FROM 
(CALL HP.SP_A_SEG_DIS (201605)) )ON COMMIT PRESERVE ROWS;
</code></pre>

<p>Any help would be appreciated!</p>