I have a report which uses a stored procedure. this procedure returns a refcuror accessing columns from a the final table. Now when i move my report template from developement to UAT environment, how do i change my database login as the report template uploaded to CMC in developement has a developement schema name which could not be changed in CMC.
I tried uploading the report template by just entering the UAT schema name but i couldnt save it as the template expects the user to loginto UAT before saving. Unfortunaltely I dont have access to UAT environment. Is there a way to counter this problem.
I heard there is way to use configuration file which holds the database login info and all i have to do is use a key specified in the file. Not sure how to do it ? Any Suggestions ?
Thanks,
Kiran