Archives of the TeradataForum
Message Posted: Thu, 20 Jan 2011 @ 10:41:14 GMT
If the Stored Procedure is making the use of Dynamic SQL, then the procedure should be created in user database only (this will be the user which should be executing the procedure).
For this, you also might need to assign some perm space to the user db, which is not ideally assigned.
Hope this helps.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|