Archives of the TeradataForum

Message Posted: Mon, 06 Aug 2007 @ 13:53:02 GMT

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

Dear Viva,

You can create procedure using Dynamic SQL only in the user database who has logged in. In your case you are logged in as DBC but are creating the procedure in database DEV_STG_CORE. You must have the user created as dev_stg_core, login as that and then create the procedure. I guess DEV_STG_CORE is the database and not the user in your case. In that case, login as some user and then create the procedure in that user database.

Regards,

Rajesh Jain

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