Archives of the TeradataForum

Message Posted: Wed, 27 Nov 2002 @ 10:35:41 GMT

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

You need to check the list of DDL/DCL/Dynamic SQL statements that are not allowed within a stored procedure and other restrictions too. (Chapter 4 : SQL Reference Volume 6) BTW, this is what the manual has to say when a volatile table is created within a stored procedure : If a CREATE VOLATILE TABLE statement is included in a stored procedure, the volatile table is created in the login user's database. If an object with the same name already exists in that database, the result is a run-time exception.DML statements within a stored procedure referencing the volatile table must either have the user's login database as the qualifier, or not have any qualifying database name.

- Narayan.

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