SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg: Packages and Global variables -

915396Oct 28 2016 — edited Nov 4 2016

Hi Experts,

I have a doubt regarding use of Global variables in packages, and the package being used by Java (front-end) application.

There is a package "PKG" with procedures P1, P2, and P3, in it. Procedure PKG.P1 is invoked from front-end application.

There is a global variable "GV" defined in the PKG body. Variables GV gets populated when PKG.P1 is invoked, and used subsequently by procedures PKG.P2 and PKG.P3.

While testing some scenario (not able to reproduce it perfectly again) concurrently in 2 diff machines, it seems variable GV in both the application calls ,is conflicting with each other values.

Is this a correct understanding?

Please help me understand the fundamentals of packaged-global-variables when used concurrently.

p.s. Currently reading this thread by Tom.

Thanks,

-Ranit

(on Oracle 11.2.0.4.0)

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2016

Added on Oct 28 2016

20 comments

5,427 views