Formspider 1.9 enables developers to run an application using the same database session for each user session. This enables developers use features of the Oracle Database such as package globals, global temporary tables etc… throughout their application. It also makes migrating Oracle Forms applications (or applications built with any technology assuming a stateful database session) to Formspider much easier and faster.
To enable this feature all a developer needs to do is to call the following API procedure
Starting with the next user event, the application will always use the same database connection.
Similarly, to go back to the stateless mode simply call:
We recommend that you start your applications in stateless mode and only allow stateful connections after the user is authenticated. Similarly, we recommend that you switch the application back to the stateless mode if a user logs out.