Home » Developer & Programmer » Forms » Logon at RunTime (oracle , forms6i ---10g, Xp)
Logon at RunTime [message #334544] Thu, 17 July 2008 01:15 Go to next message
myclassic
Messages: 127
Registered: December 2006
Location: Pakistan
Senior Member
Dear Sir

I want to disconnect my form at runtime and connect with different user name / password at run time. how it is possible?

I am using following code at WHEN-NEW-FORM-INSTANCE
///////
declare
vuser varchar2(1000):='scott\tiger@mdx';
begin

logout;

logon (vUser);

exequte_query;

end ;
//////
what is wrong with this code.... it show wrong number or type of arguments.

Regards.
Re: Logon at RunTime [message #334552 is a reply to message #334544] Thu, 17 July 2008 01:35 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
The event is wrong...

Use trigger at form level ON-LOGON and there you issue you logout and logon commands....

The EXECUTE_QUERY command is on correct trigger.
Re: Logon at RunTime [message #334553 is a reply to message #334552] Thu, 17 July 2008 01:39 Go to previous messageGo to next message
myclassic
Messages: 127
Registered: December 2006
Location: Pakistan
Senior Member
azamkhan wrote on Thu, 17 July 2008 01:35
The event is wrong...

Use trigger at form level ON-LOGON and there you issue you logout and logon commands....
.



Dear

thanks for such a quick reply.

what are the parameters of logon;

how to use it??

Re: Logon at RunTime [message #334554 is a reply to message #334553] Thu, 17 July 2008 01:42 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
The syntax is correct in your on logon statment.
Re: Logon at RunTime [message #340044 is a reply to message #334554] Mon, 11 August 2008 02:54 Go to previous message
myclassic
Messages: 127
Registered: December 2006
Location: Pakistan
Senior Member
You may use any trigger ...... paste it in when new form instance



:SYSTEM.MESSAGE_LEVEL := 25;
logout;
logon('scott@mdx11','tiger',false);
execute_query;
Previous Topic: Run forms 6i on web environment - Guidance required.
Next Topic: RELATIONS AND TABULAR FORM
Goto Forum:
  


Current Time: Fri Dec 02 14:29:05 CST 2016

Total time taken to generate the page: 0.18191 seconds