How to find exception occured while using LOGON function in oracle 10g
876659Feb 17 2012 — edited Feb 17 2012Hi,
I am using LOGON function to login with a different user name in oracle 10g forms.
LOGON ( User, Pass@tns, FALSE)
The third parameter is passed as 'FALSE' to avoid the login screen to be opened. If any of the other parameter ( User Name, Password, TNS) is passed wrong, connection is not established but no exception is occurred. The value for 'FORM_FAILURE' is set to 'TRUE'.
What i need is the ORA error for connection failure. The error message related to user name/password (ORA-01017) or connection identifier (ORA-12155).
How i can get this error code if connection is failed. Is there any other way to login in oracle forms other than 'LOGON'.
Habib