Changing SQL user From Developer 1

[taqmeena]

i HAVE a Button of a Form.
when user Press this Button.
user of Sql Should Change as specified in the WHEN-BUTTON-PRESSED TRIGGER of that button.
as
BEGIN
CONNECT ABC/DEF@GHI;
END;

KINDLY GIVE ME THE CORRECT WAY HOW CAN I DO SO.

 

[lewisp]

You will have to use the LOGOUT and LOGON built-ins in association with the ON-LOGON trigger. Have a look at the forms help for more definitive information.

Be aware that:

1. LOGON used outside the ON-LOGON trigger will fire the ON-LOGON trigger.

2. LOGON used inside the trigger will do the actual connection to the database.