My Oracle Support Banner

Global variable across different sessions (Doc ID 272560.1)

Last updated on OCTOBER 09, 2023

Applies to:

Oracle Forms - Version 6.0.8 and later
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Goal

Can we store any value using plsql package in the manner that it should be same for all sessions using that package and if any session changes that value then it should become the new value for that variable for all sessions?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.