PL/SQL (MOSC)

MOSC Banner

Possible to reset package global value after package procedure execute

edited Sep 20, 2019 2:07AM in PL/SQL (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center