PL/SQL Code – Rowe IT

Package Variable Scope

Posted on March 16, 2022March 16, 2022 by admin

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

Session-Based Application Context

Posted on March 16, 2022March 16, 2022 by admin

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