Archives of the TeradataForum
Message Posted: Mon, 06 Aug 2007 @ 13:53:02 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|