Possible to reset package global value after package procedure execute
Hi
Oracle 12.1.0.2.0
Is it possible to somehow reset global value g_val, back to the original value "0", after I have executed pck1.proc1 ?
CREATE OR REPLACE PACKAGE PCK1ASg_val NUMBER := 0;PROCEDURE proc1;END PCK1;/CREATE OR REPLACE PACKAGE BODY PCK1ASPROCEDURE proc1ISBEGINdbms_output.put_line('pck1.g_val before set: '||pck1.g_val);pck1.g_val := 1;dbms_output.put_line('pck1.g_val after set: '||pck1.g_val);END;END PCK1;/-- For executingset serveroutput on;exec pck1.proc1;-- First time executing on same sessionpck1.g_val before set: 0pck1.g_val after set: 1-- Second time executing on same sessionpck1.g_val before set: 1pck1.g_val after set: 1-- If I logout and login back again, output is followingpck1.g_val before set: 0pck1.g_val after set: 1
1