Home » Developer & Programmer » Reports & Discoverer » How to change database log in at runtime report (Oracle 10G,D2K Forms,Report 6i and IBM AIX OS)
How to change database log in at runtime report [message #494469] Tue, 15 February 2011 00:10 Go to next message
manojkumarg2gmailcom
Messages: 5
Registered: September 2010
Location: Bhopal
Junior Member
Hi,
I want to change database login in report at runtime.

For Example. I have created and run a menu by using database login "ABC/xxx" and want to run a report through this menu directly (Without using form) by different data base login i.e "xyz/ddd".



what is the sol. except passing user id at report call i.e rwrun60 parameter.

Is it possible at report level.if so, how..

Thanks

Manoj
Re: How to change database log in at runtime report [message #508531 is a reply to message #494469] Mon, 23 May 2011 00:39 Go to previous message
jaganerp@gmail.com
Messages: 63
Registered: April 2008
Member
Hi Manoj,

i hope by using the dynamic sql function we can connect write the trigger in before parameter like a:="connect :user/:password:@database", may it will work i think so, try like this.
Previous Topic: Call 6i report and Create PDF file and send mail
Next Topic: ORA-00920 error in discoverer
Goto Forum:
  


Current Time: Sun Sep 14 23:12:00 CDT 2014

Total time taken to generate the page: 0.07546 seconds