Archives of the TeradataForum

Message Posted: Thu, 20 Jan 2011 @ 10:41:14 GMT

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

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.

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