Archives of the TeradataForum

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

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

<-- 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>>