Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 08 Oct 2009 @ 13:25:24 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Volatile table in procedure
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, October 08, 2009 08:39 -->

Global temporary tables are much easier to use within stored procedures.

But if you really want to utilize volatile table within stored procedure, you must create an instance of the volatile table in same session, prior to compiling stored procedure. This will allow the INSERT to compile. The compile does syntax checking of CREATE (so may get warning that it already exists), but does not execute it.

Also note that creator of SP must be same as owner of SP.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023