When executing the oracle forms LOGOUT in-built, it is failing to disconnect the oracle database session. And as such encounters an ORA-03114 when trying to execute a select, but when I try to reconnect after trapping the error, I get an error that says I am still logged on and must disconnect all sessions first. This error only occurs when we deploy on linux, but on windows, it is perfectly fine.
Download these two files and rename p1_dept_2.fmb to p1_dept.fmb
1. Compile the forms and deploy on linux,
2. Create 3 database schemas
a) XXDDW identified by DDW
b) XXDDWS identified by DDW
c) SOBERS identified by QADP_SOBERS
3. In your formsweb config, in the setup for your launch, use p1_dept.fmx as you entry form and also default login should be set as XXDDW
4. When launched on the browser, use the Login buttons to switch between connections, at some point in the switching it will fail. Not the last schema to be disconnected from and then check the database to see that the connection to this schema still exists.
Did you manage to solve the problem with logout built in ? It looks like we experience something similar. The session drops after logout. I will appreciate if you let me know what did you do at the end ?