Archives of the TeradataForum

Message Posted: Thu, 31 Mar 2005 @ 13:39:44 GMT

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

This is a documented but frequently overlooked restriction. A quick check of the Messages manual for SPL1078 reveals:

Explanation: The reason is that the creator and the immediate owner of the stored procedure is not the same. Hence the specified DDL, DCL, or dynamic SQL statement cannot be specified in the SPL source text.

The term "creator" means the username issuing the CREATE PROCEDURE, and "immediate owner" means the database/user in which the stored procedure is actually being created. In other words, if you are logged on as USER1 you must create the stored procedure as USER1.some_name, not SomeOtherDB.some_name.

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