Package public variables and cursors can persist for the life of a session, per “Added Functionality” 103EB8529FD5https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-packages.html#GUID-F2763E50-C2C6-4A4B-AEFA-103EB8529FD5
Month: March 2022
Session-Based Application Context
A database session-based application context retrieves and sets data for the context https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/using-application-contexts-to-retrieve-user-information.html#GUID-F0968CAC-E281-4C45-BCF7-7DB157A322D1